Oracle

1. Basic Concept: the logical structure of oracle can be divided into tablespaces, segments, partitions, and data blocks ). Oracle consists of tablespaces. tablespaces consist of segments, which are composed of partitions and data blocks. 1) The

In Oracle 9, The dbstart command does not respond or report errors. 1. solution to the problem where dbstart does not respond: vi/var/opt/oracle/oratab change the N value after the corresponding instance name to Y. For example:

In oracle 11g r2, we found that the traditional exp could not export an empty table, and then looked at it and found that the following steps are required to take notes. Oracle 11g adds a parameter: deferred_segment_creation, which indicates that

OracleORA-12520: TNS: The Listener cannot find a problem with available handlers for the requested server type. view the processes and sessions parameters SQL> show parameter processesNAME TYPE when integer 1gcs_server_processes integer

1. rating function: used for rating, percentage point, n-part, etc. Function Description RANK () returns the ranking of data items in the group. If the ranking is equal, the vacant DENSE_RANK () is left in the ranking to return the ranking of data

Oracle needs to store new records to other disks through Table Partitioning: the original oracle database data files are stored on the d disk, but there is not much space left on the d disk. We recommend that you switch to the E disk as the boss.

1. ORACLE optimizer has three types of A, RULE (RULE-based) B, COST (COST-based) c, and CHOOSE (selectivity) to set the default optimizer. various declarations of the OPTIMIZER_MODE parameter in the ora file, such as RULE, COST, CHOOSE, ALL_ROWS,

Oracle SQLServer MySQL view all current database table names and other information environments: Oracle 11g + SQLServer 2008 R2 + MySQL 5.1 Oracle: 1. view All data tables in the current database [SQL] select * from all_tables; select table_name

ORA-00020, ORA-01304, ORA-27101 troubleshooting # ORA-00020 ProblemsDuring fixed-point maintenance, the "Next" mode is used for installation of the database by Windows software. All configuration parameter values are default values. But because the

Use the Alter Database statement to switch between startup modes.1. switch from NoMount mode to Mount mode (not from mount to nomount): Command: alter database mount; 2. when the DATABASE status is closed, switch to the Open mode command: alter

Oracle SQL * PLUS Common commands related to user operations 1. add database users: (user01/pwd) [SQL] create user user01 identified by pwd default tablespace users Temporary TABLESPACE Temp; www.2cto.com 2. authorize user01: [SQL] grant connect,

In Windows, when running SQL * Plus in the doscommand window, you can use the up and down keys to skip the previously executed SQL statements. you can modify them as needed and press Enter to submit them again.However, when running SQL * Plus in

During daily application development, filter-type local range scanning often encounters a need to determine whether a set that meets certain query conditions exists. In fact, this operation is essentially a special filtering operation, you need to

Understanding of oracle ITL (Transaction slot) 1. ITL Description: ITL (Interested Transaction List) is an integral part of the Oracle data block, which is located in the data block header (block header ), itl is composed of xid, uba, flag, lck, and

Oracle recursive query example analysis start with connect by Hierarchical Queries. areaid,. name,. parentid,. levelcodeFrom prnbsn_area a www.2cto.com Start With. areaid = 3 Connect By Prior. areaid =. parentid this query will find all sub-regions

Reset set linesize 200 ------------------------------------ display the width of the buffer text desc user_tables; ----------------------------------- display all the table fields and structure alter table TABLE2 modify column name date; ------------

Related Links: Exploring the RMAN_01 concept of ORACLE http://www.bkjia.com/database/201205/132243.html Explore the basic use of RMAN_02 in ORACLE http://www.bkjia.com/database/201205/132329.html ; Explore ORACLE RMAN_02 consistent backup http://www.

In oracle SQL statements, the use of single and double quotation marks/** double quotation marks in ORACLE "is treated AS a common string **/SELECT '" AS "string result" from dual; /** normally, the strings contained by two ''are treated as the

In linux, when oracle deletes a tablespace, an error occurs. Due to insufficient tablespace capacity, the tablespace capacity needs to be increased. Therefore, a new tablespace is created in the original tablespace and added to the original

In SQLPLUS, you can view the table structure in oracle, modify the table field in SQL statement 1, view the table structure in desc table name 2, modify the table field in SQL statement, and use the rename keyword to modify the field name: