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!

How to backup all the views in a table

NonudayJan 4 2012 — edited Apr 30 2012

I want export all the view in a schema.

I used the below command:

expdp A12/A12 schemas=USER INCLUDE=VIEW directory=pump_dir dumpfile=expdp_VIEW.dmp

The command executed successfully but,

Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/VIEW
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************

It seems nothing have been backed up..

I don't want to export specifically. Is there any way to upload all the views using export or any other way.

Kindly help me..

Thanks in advance

nonuday

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 3 2012

Added on Jan 4 2012

#backup, #database-key-features, #export, #export-import-sql-loader-external-tables, #oracle, #table

6 comments

1,673 views