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!

my question is about expdp. i want to export tablespaces individually..

3035397Jan 21 2016 — edited Jan 22 2016

Hi all, i am a beginner. i am using Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

i tried to export tablespace SYSTEM using expdp but got error as like this

expdp directory=export1 dumpfile=dmp12.dmp logfile=loggg.log tablespaces=system;

Total estimation using BLOCKS method: 0 KB

ORA-39167: Tablespace SYSTEM; was not found.

ORA-31655: no data or metadata objects selected for job

Job "SYS"."SYS_EXPORT_TABLESPACE_01" completed with 2 error(s) at 18:16:48

but when i tried with multiple tablespaces (SYSTEM,SYSAUX)

expdp directory=export1 dumpfile=dmp12_1.dmp logfile=loggg2.log tablespaces=system,sysaux;

its working fine..

please, rectify me if i am wrong and please explain about the problem.

Thanks in Advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 19 2016

Added on Jan 21 2016

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

8 comments

2,064 views