✍ Kashif M
Trends

Wednesday, 21 August 2013


export schema without data in oracle


By on August 21, 2013



exp username/password file=filename.dmp statistics = 'none' rows=n


Imp - export the schema

username - provide the scehma which you need to export 

password - provide the password of corresponding schema

statistics - Specifies the type of database optimizer statistics to generate when the exported data is imported

rows = n  - It will ignore all the rows and it will export only struture of the schema.


Thanks
kashif 

Kashif
mkashu: export schema without data in oracle
Review : Kashif | Kashif
Update: August 21, 2013 | Rating: 4.5

Comment for "export schema without data in oracle"

0 comments

Post a Comment

Blog Archive