How to make temporary tablespace offline? and one more question!
360792Aug 2 2008 — edited Nov 18 2008Dear 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