Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Export /Expdp without data

621707Jun 18 2009 — edited Oct 16 2012
I want to export only database structure without table data.
How can i achive this with EXP and EXPDP?

Does in EXP we need to give rows = no so that no row will be exported?

Thanks,
This post has been answered by Florian W. on Jun 18 2009
Jump to Answer

Comments

Florian W.
Answer
Dear ora_2009!

expdp: 
expdp username/password DIRECTORY=directory_object_name \
                        DUMPFILE=dumpfile_name \
                        TABLES=table_names|TABLESPACES=tablespace_names|FULL=y \
                        CONTENT=metadata_only
exp: 
exp username/password GRANTS=y \
                      CONSTRAINTS=y \
                      ROWS=n
Yours sincerely

Florian W.

Edited by: Florian W. on 18.06.2009 12:34

Edited by: Florian W. on 18.06.2009 12:38
Marked as Answer by 621707 · Sep 27 2020
Satish Kandi
ora_2009 wrote:
I want to export only database structure without table data.
How can i achive this with EXP and EXPDP?

Does in EXP we need to give rows = no so that no row will be exported?

Thanks,
For traditional export, the parameter is ROWS
For Data pump export, the parameter is CONTENT set to METADATA_ONLY
1 person found this helpful
621707
Thanks a lot.
968796
Thank you so much it was very helpful
unknown-7404
I bet he's been waiting faithfully by his computer for three years to hear you say that! :D
1 person found this helpful
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 13 2012
Added on Jun 18 2009
#database-key-features, #export-import-sql-loader-external-tables
5 comments
147,493 views