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!

Problem Exporting 'USER' Tablespace Metadata

736291Nov 21 2009 — edited Nov 23 2009

I am having problem using Data Pump Export to export the 'USERS' tablespace metadata.

When I make the USERS tablespace read only and run the Data Export job, the job aborts with "ORA-01647: tablespace 'USERS' is read only, cannot allocate space in it."

But then when I make the USERS tablespace read and write, the job aborts with "ORA-29335: tablespace 'USERS' is not read only."

I've been caught in this CATCH-22 for the 2nd day now, and I could really use some help. I'm on a Windows 32 platform running Oracle 10g, and here is a copy of the Data Pump Export script/command that I am running at the operating system prompt, which works fine for other tablespaces' metadata, like 'EXAMPLE':

$ expdp myusername/**mypassword* TRANSPORT_TABLESPACES=users TRANSPORT_FULL_CHECK=Y DIRECTORY=dtpump DUMPFILE=expdp_users.dmp logfile=expdp_users.log

Thanks!