Skip to Main Content

Oracle Database Discussions

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 make temporary tablespace offline? and one more question!

360792Aug 2 2008 — edited Nov 18 2008
Dear experts,

Oracle 10g locally installed on XP machine

I have two questions:

1) I want to remove two tablespaces (1 normal & 1 temporary) which are also having some associated data and temp files. For doing so, I have to make these tablespaces offline first, then only I can drop them. I did able to make normal tablespace offline but not the temp one. it is giving an error 'ORA-03217: invalid option for alter of TEMPORARY TABLESPACE'.

2) I exported data from one user and importing into different user with different tablespaces in the same database but it is giving an error
IMP-00003: ORACLE error 1542 encountered
ORA-01542: tablespace 'MAJANDC_DATA' is offline, cannot allocate space in it
IMP-00017: following statement failed with ORACLE error 1542:

Waiting for your quick and helpful resposne please.

Thanks and regards,

Zia
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2008
Added on Aug 2 2008
10 comments
8,133 views