Oracle

1, the concept of table spaceOracle databases are divided into logical regions called table spaces-the logical structures that form Oracle databases. An Oracle database can have one or more tablespaces, while one table space corresponds to one or

1. Start time and end time of the week Start time for the week, starting with Monday. SELECT TRUNC (Date ' 2016-05-12 ', ' D ') + 1 from DUAL; End time of the week, ending with Sunday SELECT TRUNC (Date ' 2016-05-12 ', ' D ') + 7 from DUAL;

Definition: A stored procedure (Stored Procedure) is a set of SQL statements that are compiled and stored in a database in order to complete a specific function. The user specifies the name of the stored procedure and gives the parameter, if the

Environment: Oracle 11g R2 +sqlplus problem: Oracle with SYS and system default password login prompt Ora-01017:invalidusername/password;logond denied As we all know, the default password for SYS is Manager,system's default password is

1 ORA-00955 2 ORA-12514 ORA-12504 3 command line unable to log in 1 ORA-00955 This error occurred while building the table, the name is already used by the existing object (name is already used by a existing object), let's analyze it.First, you must

Win+r Open the Run window, enter cmd into the command line: Enter the Sqlplus, enter the username, enter the password (if it is Super admin sys, add as as SYSDBA after the password) and enter the SQL command line; When the connection succeeds, type

to view the recovery after the Table drop table in the Recycle Bin Select Object_name,original_name,partition_name,type,ts_name,createtime,droptime from RecycleBin; Sql>flashback table "Bin$b+xkko1rs5k10uko9bfmua==$0" to before drop; Delete

1 oracle10g Uninstall Software Environment:1. Windows XP + Oracle 10g2, the Oracle installation path is: d:\OracleImplementation method:1, Start-> Settings-> Control Panel-> Management Tools-> Services to stop all Oracle services;2, Start-> Program->

1. Basic Grammar SELECT * from table [start and Condition1] connect by [prior] Id=parentid1 It is commonly used to find data that has a parent-child relationship, that is, a tree-structured data, and its return data can clearly differentiate

The start database command is divided into three phases: Startup Nomount ALTER DATABASE Mount ALTER DATABASE Open 1. View All Users:SELECT * from Dba_user;SELECT * from All_users;SELECT * from User_users;2. View User system permissions:SELECT *

① Make sure you have full control of the folder. Folder Point right--> property-> Security-> Advanced-> owner-> change to own-> edit own permissions for Full control.② changes the compatibility of Setup.exe to Windows Server 2003 (Server Pack 1).

--t_veh_traffic_vio Illegal table --vhcl_info Vehicle Information table --Single table modification, revision of April 2014 illegal data synchronization sign bit update T_veh_traffic_vio t Set T.synchflag = 0, T.synchstatus = ' u ' where T.WFSJ

Instance recovery mechanism With the Redo,undo and incremental ckpt concepts, it helps to better understand instance recovery When an instance crashes, the DB buffer in memory is inconsistent with the datafile on the disk. Two issues to

Later checked the data, found that table space data file capacity and db_block_size, in the initial construction of the library, db_block_size to be based on actual needs, set to 4k,8k, 16K, 32K, 64K and other sizes, Oracle's physical files allow

Oracle Set table space not Limited 1. View each table space status SELECT file_name,tablespace_name,autoextensible from Dba_data_files; 2. The table space is infinitely large alter DATABASE datafile '/U02/ORADATA/RSJDB/USERS01.DBF ' autoextend

An efficient way to remove duplicate data Table demo is duplicate copy from Dba_objects, has about 880,000, does not repeat is 27323, no index Method One: Delete from demo a where A.rowid <> (select Max (ROWID) from demo B

Create a database user Drm_test in an Oracle database, and Grant "CONNECT", "RESOURCE" two permissions ALTER USER "drm_test" DEFAULT role "CONNECT", "RESOURCE"; Then use this user login to create a view when prompted (insufficient permissions):

 1.1 Definition of the index The index resembles the directory structure of the book, and you can quickly find what you need based on the page numbers in the table of contents. An index is a separate, physical database structure that is a

Learn about Oracle hash connections quickly [ Introduction] Here you will need to set hash_join_enabled=true for an Oracle hash connection to be valid, by default this parameter is TRUE, and do not forget to set the Hash_area_size

Oracle Functions--common functions NVL (EXPRESS1,EXPRESS2): If the first expression is empty, the value of the second expression is displayed; If the first expression is not empty, the value of the first expression is displayed; NVL2