oracle 12c database new features for dba

This is an Oracle small white unbearable torture, struggling to make, the cost of painstaking efforts.Differences between ORACLE12C and 11g versionsA problem was encountered while creating the user (my findings are based on the problems encountered):Problem Description:Prompt for ORA-65096 when creating the required user for the service: the public user name or role is invalid.Cause of the problem:According to Oracle's official documentation, the

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

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

explicitly inserted; METADATA-ONLY default value refers to the default value specified when a new column is added, and the difference in 11g is that, the default value of 11g must be not null. 3. extend the length limit of multiple data types: Increase the VARCHAR2, NVARCHAR2, and RAW types to 32 K, set compatibility to 12.0.0.0 or above, and set the initialization parameter MAX_ SQL _STRING_SIZE to EXTENDED, this function does not support CLUSTER ta

Prior to the Oracle 12c version, the VARCHAR2 and NVARCHAR2 data types had a maximum length of 4000, with the extended maximum of 12c versions supported to 32767, or 32KB, and parameter Max_string_ The size is the maximum length of the extended data type that controls the extended datatype: Standard: Represents the length limit before

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

;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

The new feature of Oracle 12c paging query is expected in the upcoming oracle 12c release. This is the optimization of paging query. There are many paging query functions in the application. Previously we used rownum for this purpose.For example, to query 1-10 records, the q

Oracle new features 4-maintenance, upgrade, recovery and data pump, and oracle New Features 1. Contents 1) enhanced table partition maintenance. 2) Database Upgrade and improvement. 3)

at the end of 2013, it further expands the comprehensive portfolio of Oracle products in application, social networking, platform and infrastructure services. At the same time, Oracle recently released a series of cloud-oriented Database and software integration products, including Oracle

platform called Goldengate STUDIO, a graphical interface that helps to quickly configure and deploy Ogg. Use mouse clicks and drag to implement Ogg deployment without worrying about the underlying details. The idea of OGG Studio is that first there will be a project, and then there are multiple solutions, each of which includes multiple logical designs and multiple physical deployments. Ogg Studio already has multiple out-of-the-box scenario templates, such as cascading, bidirectional, unidirec

/oracleSql> Conn system/oracleconnected.sqlSelect name from V$datafile;name----------------- ---------------------------------------------------------------/u01/app/oracle/oradata/mydb/system01.dbf /u01/app/oracle/oradata/mydb/sysaux01.dbf/u01/app/oracle/oradata/mydb/undotbs01.dbf/u01 /app/oracle/oradata/mydb/users01.

Oracle First week: Flash back query Get a movie instead of a picture: Flash back version query No setting required to immediately recognize all changes to a row In the Oracle9i Database, we saw that it introduced a "time Machine" in the form of a flashback query. This feature allows the DBA to see the column value at a specific time, provided that the previo

-logical Record Count 192Commit point reached-logical Record Count 256Commit Point Reached-logica L Record Count 320Commit point reached-logical Record Count 384Commit point reached-logical Record Count 448Commit poi NT Reached-logical Record Count 512Commit point reached-logical Record Count 576 ..... Commit Point reached-logical Record Count 90589Commit point reached-logical Record Count 90653Commit Point reached-l Ogical Record Count 90717Commit point reached-logical Record Count 90756Table "

At the Oracle OpenWorld Conference in San Francisco in 2015, Oracle released the beta version of database 12.2, although the beta version is only available to some users, But the conference has unveiled 12.2 of the most important new features, and cloud and Emme are beta use

Before Oracle11.2, you must register the public IP address and virtual IP address of the node to the DNS server to connect the client to the database normally and support Server Load balancer. Dimensions of some clusters Before Oracle 11.2, you must register the public IP and virtual IP of the node to the DNS server to connect the client to the database normally

BKJIA exclusive Article: First of all, this article is not a detailed list of new features of DB2 9.7. I only list a list that is very important to DBAs or developers. Online solution Modification Please refer to Burt's article on online solution modification at: http://www.ibm.com/?works/data/library/techarticle/dm-0907db2outages/index.html. CGTT-create a global temporary table Now you can create a global

Five types of policies, column-related policies, and column masks make VPD a more powerful tool in the DBA's security toolbox The Virtual Private database (VPD), also known as fine-grained access control, provides powerful row-level security features. It was launched in Oracle8i and has been widely welcomed and used in a variety of applications, from educational software to financial services. VPD's appro

generation level for system components. User accounts can be unlocked through the Web UI. Newly added built-in reports: Oracle Database Vault Report, summary reports, IRS compliance reports, reports correlate Database Audit Events W ITH OS users, used su or to sudo execute commands. The host monitor and audit Vault agent details are added to the Host tab in the

recovery is enabled, the rollback occurs in parallel rather than serially, as if it occurred in a regular transaction rollback. The next task is to evaluate the completion time of the rollback process. View V$fast_start_transactions shows the transactions that are generated by the rollback failure transaction. A similar view v$fast_start_servers displays the number of parallel query servers that are processed for rollback. Both views are available in previous versions, but the