oracle 12c new features for dba

New Features of Oracle DB 12c: raw device bare devices are no longer supported, oracle12c New Feature of Oracle DB 12c: raw device is no longer supported. Reference:Announcement of De-S

; INSERT INTO invisible_t (ID,NAME,PASSWD) VALUES (1, ' Andy ', 1);1 row created.sql> INSERT INTO invisible_t (Id,name) VALUES (2, ' andy02 ');1 row created.3. Query statusSql> select * from invisible_t;ID NAME---------- --------------------1 Andy2 andy02Sql> select Id,name from invisible_t;ID NAME---------- --------------------1 Andy2 andy02Sql> select id,name,passwd from invisible_t;ID NAME PASSWD---------- -------------------- --------------------1 Andy 12 andy024. Modify field to visible or

New Features of Oracle 12C-online migration of table partitions or subpartitions Oracle 12c: new feature-online migration of table partitions or subpartitions. It is no longer necessar

has been strengthened again, we can not set the NOT NULL here, greatly reducing the possible error operationSee the following experimental processCREATE table T, where more than 1 million rows of data.Sql> Select COUNT (*) from T; COUNT (*)---------- 1454256Add a column directly to the table (not set NOT NULL)Sql> ALTER TABLE t add MRDAI1 number default 10000; Table altered. elapsed:00:00:00.03The speed is swift. And, of course, as in 11G.After the setting is complete, if it is a newly inser

The new features of In-database archiving are introduced in Oracle Database 12c, which allows users to archive data by marking data rows on the table as inactive inactive. These inactive data rows can be compressed into one optimization and are not visible to the app by default. This feature enables the functionality a

One, DB default character set Al32utf8Specify the database character set when you create the database. Starting from Oracle Database 12c Release 2, if you use Oracle Universal Installer (OUI) or Oracle database Configuration Assistant (DBCA) to create a database and then the default database character set used is the U

reserved Records is 100Sql>set History 3;7. View Hist retained RecordsSql> hist list;1 show Con_name2 show parameter version;3 Show hist;Description: The number of records retained is calculated by command rather than by line count.8. Run the specified recordSql> hist;1 Select sysdate from dual;2 show Con_name3 Select date from dual;Sql> hist 2 run;Con_name------------------------------Cdb$root9. Edit the previous commandhist 1 edit;Description: You can operate like Linux VI and edit the retain

(2, Seq_session.nextval); SQL>Select* fromSCOTT.GTT; ID Seq_number---------- ----------1 3 2 4SQL>Continue the test.--end of session, sequence value will be resetSql>conn tiger/Tigersql>drop synonym GTT; SQL>drop synonym seq_session; SQL>create synonym GTT forSCOTT.GTT; SQL>create synonym Seq_session forscott.seq_session; SQL>Select* fromgtt;no rows Selectedsql>sql> INSERT INTO GTT values (1, Seq_session.nextval); sql> INSERT into GTT values (2, Seq_session.nextval);-I

;Table altered.--View index statusSql>Col index_name for A25Select Table_name,index_name,status,blevel,leaf_blocks,orphaned_entries from user_indexes where index_name = ' IDX_ Andy_id ';table_name index_name STATUS blevel leaf_blocks ORP------------------------- ------------------------- -------- ---------- ----------- ---Andy_move idx_andy_id VALID 0 0 NO--Move online partition table errorSql> ALTER TABLE P_andy move online;ALTER TABLE P_andy move online*ERROR at line 1:Ora-14808:table does not