#undo tablespace
SQL>create undo tablespace undotbs2 datafile '/new_location/newundo02.dbf' size 2000m;
#Set new tablespace as undo tablespace
SQL> alter system set undo_tablespace= undotbs2 ;
#Drop old undotbs tablespace
SQL> drop tablespace undotbs including contents;
Friday, March 6, 2015
relocate undo tablespaces oracle
Subscribe to:
Post Comments (Atom)
ALCATEL 6900
write memory copy running certified reload from working no rollback-timeout
-
grant execute on utl_http to wc grant execute on dbms_lock to wc; BEGIN DBMS_NETWORK_ACL_ADMIN.create_acl ( acl => &...
-
``` sda: add missing path sda: failed to get udev uid: Invalid argument sda: failed to get sysfs uid: Invalid argument sda: failed to ge...
-
OracleMTS Recovery Service error "Windows could not start the OracleMTSRecoverService service on Local Computer. Error 1: Incorrect fun...
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.