$ sqlplus / as sysdba SQL> show parameter undo NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management string AUTO undo_retention integer 900 undo_tablespace string UNDOTBS1 SQL> create undo tablespace undotbs2 datafile '/data/data_files_xe/undo02.dbf' SIZE 4G; alter system set undo_tablespace= undotbs2 SCOPE=BOTH; drop tablespace UNDOTBS1 including contents AND DATAFILES;
Knowledge is a familiarity, awareness or understanding of someone or something, such as facts, information, descriptions, or skills, which is acquired through experience or education by perceiving, discovering, or learning. Knowledge acquisition involves complex cognitive processes: perception, communication, and reasoning; while knowledge is also said to be related to the capacity of acknowledgment in human beings. Health Related Link http://goodhealthstrongwealth.blogspot.in/
Sunday, October 21, 2012
Change or switch undo tablespace in Oracle database

Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment