|
-
PWC.... you're LUCKY
You can just recreate the tablespace TEMPORARY
when no more user logged in to your db(or you can bounce your db and login with restrict mode).
alter tablespace TEMPORARY offline;
drop tablespace TEMPORARY;
create tablespace TEMPORARY datafile 'C:\ORANT\ORADATA\PRD\TOTO_TEMP1.ORA' size100M reuse online temporary;
alter tablespace TEMPORARY add datafile 'C:\ORANT\ORADATA\PRD\TOTO_TEMP2.ORA' size 100M reuse;
Did I miss something guys? Hope not.
good luck.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|