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!

backup schema

Annamalai AJan 25 2012 — edited Jan 27 2012

Hi experts,

i have taken schema level backup with SYS user credential, i read some where CONSISTENT=y is unsupported for exports that are performed when you are connected as user SYS or you are using AS SYSDBA, or both. i have been used expdp sys/pwd schemas=dbprod directory=DIR dumpfile=AM.dmp logfile=expdpAM.log on oracle 11.2.0.2 / AIX

can i use this exisiting backup dump file for future purpose, or have to take again with system or other users. Please guide me,

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2012

Added on Jan 25 2012

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

7 comments

360 views