$ 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
This is Vamsi Krishna Teacher ( 20 years Experience), Astrologer (20 years Experience), Entrepreneur ( As an Amway Distributor From 2004) / Software Engineer ( Oracle DBA From 2007 to till now ), Certified Nutritionist ( 10 years Experience in Health counselling for adults and children ). Please do follow and subscribe our channel.
This channel Contains to Education, Astrology, Health, Tips and Tricks, Devotional Etc.
https://www.youtube.com/c/BhavamCreations
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment