Oracle

PLUSTRACE included in SELECT_CATALOG_ROLE Autotrace is already included in SELECT_CATALOG_ROLE, that is, you do not need to grant plustrace to user. SELECT * FROM DBA_TAB_PRIVS where grantee = 'select _ catalog_role' AND TABLE_NAME IN ('v _ $

For example, there are two users in oracle, sysdb and hellodb, and table hello under sysdb. There is a baby table in hellodb. Now I want to use the hellodb User table baby in oracle user sysdb. select * from baby @ link_hellodb www.2cto.com =========

An oracle 10g is installed in linux when I log on to sqlplus. After I log on to sqlplus, I see www.2cto.com SQL> startup ORACLE ??????? Total System Global Area 167772160 bytes Fixed Size 1218316 bytes Variable Size 67111156 bytes Database Buffers 96

Create temporary tablespace www.2cto.com SQL code create temporary tablespace test_temp tempfile E for dome1 users: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf 'size 32 m autoextend on next 32 m maxsize 2048 m extent

(1) freeWww.2cto.comA common problem is:How much memory is used by my applications, servers, users, and system processes? OrHow much memory is available now? If the memory used by running processes is greater than the available RAM, you need to move

The strange DECODE function encountered the following problem today: www.2cto.com order by decode (column_id, 1, null, 2, null, 3, null, column_id, that is, when the number of columns is greater than 10, the column_id order is 10, 11, 12, 13, 6, 7, 8

Red Hat to install oracle 10g system environment configuration script redhat before installing oracle linux needs to configure some system environment, each configuration is troublesome, for convenience, write a simple script, in rhel5.8 system test

In linux, oracle needs to set two environment variables, ORACLE_HOME and ORACLE_SID, and then add the ORACLE bin directory to the PATH. Generally, ORACLE_SID = orcl is installed by default, ORACLE_HOME =/home/oracle/product/10 ...... in this form,

To start or stop a service in oracle in linux, you must have sysdba permissions. Two methods can be used for connection: first, connect to c: \> sqlplus sys/change_on_install as sysdba; Second: www.2cto.com C: \> sqlplus/nolog SQL> connect/as sysdba

Add a sequence number for the read data in oracle. When we demonstrate the Report to the customer, the customer sometimes puts it in the first column of the report, can I add a serial No. www.2cto.com? But if I modify the program code, it can be

When the oracle system is busy, quickly locate 1. Check the current number of connections select count (*) from gv $ session; www.2cto.com 2. Here we are the bs architecture, let's take a look at the general situation of the session for the

Oracle assigns permissions to log on to the database www.2cto.com as an administrator. create user: create user [username] identified by [password]; grant logon permission: grant create session to [username]; grant table creation permission: grant

Oracle SQL analysis tool uses explain plan to analyze SQL statements: www.2cto.com explain plan is a good tool for analyzing SQL statements. It can even analyze statements without executing SQL statements. through analysis, we can know how ORACLE

Restrictions on the Use of sequence objects in Oracle NEXTVAL and CURRVAL are only valid in SQL statements and not directly valid in SPL statements. (However, SQL statements using NEXTVAL and CURRVAL can be used in SPL routines) The following

When creating a unique constraint, the OCP will forcibly create or reuse the index www.2cto.com (if no index exists in the previous column, the created index is a unique index. In this case, the index name and the constraint name are the same, and

Oracle online redo log recovery (redo log) Non-current online log File fault recovery www.2cto.com 1. ORA-00313 error when starting the database. ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1:

Basic management of Oracle 10g RAC spfile --- SPFILE www.2cto.com will be created when DBCA is used to create a database --- SPFILE must be created on the shared volume or shared raw device --- all instances use the same SPFILE --- if you manually

Oracle COALESCE function syntax is COALESCE (expression 1, expression 2 ,..., expression n), n> = 2. The function of this expression is to return the first non-null expression. If both are null, a null value is returned. Note: All expressions must

ORACLE recycle bin sortingIn principle, the Recycle Bin is a data dictionary table that stores information about database objects deleted by users. Objects deleted by a user are not deleted by the database and still occupy space. Unless the user

Oracle maintenance, monitoring, and optimization of common SQL 1) SQL monitoring www.2cto.com SELECT SE. sid, schemaname, SE. serial #, PR. spid, SE. status, SUBSTR (SE. program, 1, 10) PROG, SUBSTR (SE. machine, 1, 10) MACH, SQ. SQL _text FROM v $