Oracle

Title There are several places to be aware of when installing Oracle on Linux Systems 1. Select the System version 650) this.width=650; "src="%5c "title=" \ "1.png\"/"alt=" wkiol1mq6dmtvd4zaad0ygvy21k144.png\ "/>

Revocation ManagementWhat is undo data:1. Transaction fallback: No transaction submitted can be rollback2. Transaction recovery: When the database crashes, the incorrect data of the disk is restored to the pre-transaction3. Read consistency: The

  Configuring Monitoring (1) Oracleoradb11g_home1tnslistener: Indicates the listener service, which must be turned on if the client wants to connect to the database. The service also has to work in the development of the program. (2)

Export from source database:exp user1/pwd@server1file=c:\temp\exp.dmp tables=(table1, table2)Import to target database:imp user2/pwd@server2file=c:\temp\exp.dmp tables=(table1, table2)Oracle has the advantage of being able to export remote data

Error deleting database table resolution methodSql> ALTER TABLE test1 enable row movement;//The line move function must be started before flash back otherwise an error is reported: ORA-08189: Cannot flash back to table because the line move feature

Sometimes this is a problem, we need to query a table, and to sort by business, for example, I need the following results:Area Date fee Product number user number290 201202 258 1 s1290 201202 1 S5290 201202 1 S100290 201202 2 S7290 201202 2 S9290 201

Pro-Test availableIn Oracle database operations, we sometimes use lock table queries and operations such as unlocking and kill processes, so how are these operations implemented? In this paper, we mainly introduce this part of the content.(1) The

ORACLE detailed installation and uninstallation stepsOracle Installation Steps1, the Win32_11gr2_database_1of2.zip and win32_11gr2_database_1of2.zip extracted to the current directory (PS: Select two compressed Package right-click Extract to the

B-tree and the B+treeat present, most database systems and file systems are used B-tree or its variants B+tree as the index structure. first, for a single node, it is a Key Value structure, Key is the column that makes the citation, value There are

1. View the respective roles owned by all users in the database:SELECT * FROM (SELECT DISTINCT Connect_by_root grantee username,granted_roleFrom Dba_role_privsConnect by prior Granted_role =grantee) awhere exists (select 1 from dba_users b where

1. View /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.oraCat/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# Tnsnames.ora Network Configuration File:/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora#

Instance ManagementMonitorStart monitoring:$ NETSTAT-TLNP | grep 1521$ lsnrctlLsnrctl> Help$ LSNRCTL Status$ lsnrctl Stop$ netstat-tln | grep 1521Fast Dynamic registration: (optional)$ sqlplus/as SYSDBASql> alter system register;$ LSNRCTL

Oracle The version is very many, first look at a version of the 11g description:Attention: after the Oracle 9.2 version number, Oracle's maintenance release numbers are changed at the second digit bit. And before that is in the third digit digit.1.

Oracle Database IndexIn a relational database, an index is a database structure that is related to a table, which enables the SQL statements that correspond to tables to execute faster. The index acts as a catalog of books, and you can quickly find

1. View All Users:SELECT * from Dba_users;SELECT * from All_users;SELECT * from User_users;2. View user or role system permissions (System permissions that are directly assigned to a user or role):SELECT * from Dba_sys_privs;SELECT * from

Drop,delete,truancate Table Recovery in OracleIn Oracle, there are often errors that cause the table to be deleted, and here are some of the methods I've written to restore the table.The flashback mode satisfies the criteria ( enabling the Flashback

(Create TABLE table name (field) storage (Buffer_pool keep); --cache the table to keep in the table name storage (Buffer_pool keep);--caches existing tables to keep CREATE TABLE table name (field: ) Storage (Buffer_pool Keep) cache;--create cache

After Oracle is installed, the default archive mode is turned on, and a large number of logs fill the disk instantaneously, so in the development environment, it is often necessary to turn off archive mode.1. Connect to the database as an

A Path to Oracle log: Login: Sqlplus "/as sysdba" View path:sql> select * from V$logfile; Sql> select * from V$logfile; (#日志文件路径) two. What the Oracle log file contains: (The number of logs may vary slightly) Control01.ctl example01.dbf redo02.log

Before the work encountered a problem, need to find all the sub-nodes under the tree structure, if the program will be repeated query database, the performance has an impact on the online search, you can use Oracle recursive query, examples are as