-
Can i reduce the size of UNDO tablespace datafile..??
the actual size
===========
SQL> select tablespace_name,sum(bytes) from dba_data_files group by tablespace_name;
TABLESPACE_NAME GB
------------------------------ ----------
UNDO 3
space occupied
===========
SQL> select tablespace_name,sum(bytes) from dba_segments group by tablespace_name;
TABLESPACE_NAME MB
------------------------------ ----------
UNDO 198
now when i am resizing the datafile to 1GB i am getting this error..
SQL> ALTER DATABASE DATAFILE '/oradata/u01/undo01.dbf' RESIZE 1024M;
ALTER DATABASE DATAFILE '/oradata/u01/undo01.dbf' RESIZE 1024M
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
can someone help me with this.
-
Create a new UNDO tablespace, drop the old one.
For details check Metalink Note 431652.1
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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
|