Oracle

 1. Log in to the database with the SYS accountSQL Plus Enter the command below: Conn SYS as DBA; Enter the password after the return.Tip: The connection succeeds with the second step.2. Modify the port number bitSQL Plus Enter the command below:

The partition exception for some large tables in the production library requires an online operation on the existing table to add the missing partition, because it is a production library, or a little cautious, and is available today, testing the

Oracle establishes tablespaces and usersSteps to establish a tablespace and User: Create user username identified by "password"; authorization: Grant create session to username; Grant CREATE table to username; Grant create

1. Compare Hard parse:Sql> CREATE TABLE T as select * from Dba_objects;The table is created.Time used: 00:00:00.92Sql> Set Linesize 1000Sql> set Autotrace onSql> Set Timing onSql> Select COUNT (*) from T;COUNT (*)----------79691Time used: 00:00:00.24

Recently not busy, has been using PowerDesigner to look at the table structure, has not been imported, today tryTo import Oracle tables into PowerDesigner:1, File--->reverse enginner---> datebase popup New Physical Data Model window, DBMS Select

Oracle SQL statement Tracking1 SQL statement TrackingThe execution of the trace SQL statement takes place on the Oracle server side, and the Oracle server detects and records all SQL statements executed by the access process. The commands used below

Recently Fanhun the data of Oracle in the wake of his brain.1, first put the data now have a good backup, backup is a good habit, remember every operation database must have a backup.2. Select * FROM table name as of timestamp to_date (' Want to

Version info: CentOS6.5 + oracle11g1, monitor color error: + MB. 13199 mb . 3071 MB of colors >>> command/usr/bin/xdpyinfo not available Automatically check the display color. Check to see if the DISPLAY variable is set. failed

Inserting a date value using a specific formatInsert intoEMPValues(7950,'Zhangsan','MANAGER','7782', To_date ('1988-11-11','YYYY-MM-DD'),1200.00,50.00,Ten);Insert intoEmpvalues(7951,'Zhangsan','MANAGER','7782', To_date ('1988/11/11','YYYY/MM/DD'),1

Alter session Set Nls_date_format = ' Yyyy-mm-dd,hh24:mi:ss '; set linesize 400col sql_id format a20col name format A20col da tatype_string format a14col value_string format A20select sql_id,name, datatype_string, last_captured,value_string from

Issue: The updated UPDATE statement is always updated where the card is executing the UPDATE statement.Methods to clear:Oracle Table Deadlock CancellationI'm working on plsql. 1. Query select * from V$locked_object V, dba_objects o where v.object_id

One: An optimization approach to SQL statements1. Select the appropriate Oracle Optimizer(1). RBO optimization based on rules --oracle 10G was thrown away(2). CBO optimized optimizer based on cost (CPU and memory occupancy) - The model used by the

Reference: http://jingyan.baidu.com/article/3aed632e7a638b70108091dd.htmlLinux under the Orale reference: http://blog.sina.com.cn/s/blog_4b0210750100odkf.htmlSelf-Summary:1, create a database instance, in the system service will add a service,

1 DECLARE 2V_productid Productinfo.productid%TYPE;3V_productnameVARCHAR2( -); 4V_productprice Number(8,2); 5V_quantity Number(Ten); 6V_desperation CONSTANT V_productname%TYPE:='Test'; 7 8V_spitgr Simple_integer:= 99.9; 9V_longLONG:='Long

First, createsys;//system Administrator with the highest privilegessystem;//Local Administrator, sub-high privilegescott;//Normal user, password default is tiger, default unlockedSecond, landingSqlplus/as sysdba;//Login SYS accountSqlplus Sys as

About Oracle Cluster RegistryAbout Oracle Cluster RegistryOracle Cluster Registry (OCR) is a file that contains information about the cluster node list and instance-to-node mapping information. OCR also contains information about Oracle Clusterware

Oracle Memorandum 1 Database Administrator: Install and upgrade the Oracle database to create a database, tablespace, table, view, and index... Develop and implement backup and repair plans database permission management, tuning, and troubleshooting.

Oracle listening lsnrctl command startup error (TNS-12537, TNS-12560, TNS-00507) When logging on to an oracle user in LINUX and starting a database using the lsnrctl start command, the following error is returned: "[Oracle @ localhost ~] $

About oracle11g audit files Audit: The audit option enabled by default for 11g. The default value of the AUDIT_TRAIL parameter is DB, which indicates that audit data will be recorded in the base table of the audit dictionary in the database. In

You are not authorized to create a view in Oracle. Q: After using scott to log on to Oracle, the system creates a view and prompts "insufficient Permissions". How can this problem be solved?Answer:This is because scott has no permission to create a