Oracle

DBLINK is used in DBLINK and other syntax projects to summarize: When you want to access data in another database table across local databases, A remote database's dblink must be created in the local database. You can access the data in the remote

"The Oracle client and network components are not found. These components are .. "solution" and Oracle client and network components are not found. These components are provided by Oracle and part of Oracle 7.3.3 (or higher) customer software

Oracle deletes tables starting with Bin to delete tables starting with Bin, that is, tables that are already DROP but exist in the recycle Bin: --> www.2cto.com query all such tables SQL> SELECT * from recyclebin where type = 'table'; Delete All

ORA-03113: end-of-file on communication channel address the loss of an INACTIVE log group simulation on www.2cto.com today, encountering ORA-03113 SQL> select group #, archived, status from v $ log; GROUP # arc status ---------- --- ----------------

Oracle Data Pump import/export Syntax 1. first create a directory: www.2cto.com create directory name as 'a directory on the database server ', such as: create directory alias as 'd: \ Server Directory name'; put the imported or exported files in

When the Oracle index prompts parsing hints, in some cases, we may specify a full set of hints to ensure that the optimizer produces the optimal execution plan. Oracle index prompt, oracle index prompt, oracle index tips, oracle index OPTIMIZATION,

Oracle modifies the default time format 1. insert the current time to the database insert the current date to oracle (using sysdate) Example: insert into table (date) value (sysdate ); // insert is system time and date time accurate to day current

Oracle table delete restores data through the flash back function Step 1: Determine the deletion time point and locate the SCN. Then, we need to follow the SCN to make the table flash back to the state of the SCN point www.2cto.com SQL code select

ORACLE sets the process priority in the operating system. We can use the renice command to set the process priority so that the process can obtain the CPU time slice first. In www.2cto.com ORACLE, the parameter _ high_priority_processes can also be

When oracle manually adds a database and starts the database instance normally, 1. manually delete the old database. Stop the running database www.2cto.com SQL> shutdown immediate; enter the Mount database (load the instance and open the control

The UTL_FILE package of ORACLE UTL_FIle is used to read and write files in the operating system, provided that the Directory object and authorization are created first. Then you can use the types, procedures, and functions provided in the UTL_FILE

Oracle uses scripts to create data table space and users -- Create Table space (enterprise database) ----- declare v_rowcount number (5); begin select count (*) into v_rowcount from dual where exists (select 1 from dba_tablespaces where

Authorization of oracle learning records (1) oracle learning records, Table query and execution of Stored Procedure authorization, and use of grant statements for reference. Www.2cto.com [SQL] -- use the sys user to connect to the database and

Oracle Learning Record authorization (2) oracle Learning Record and authorization. New Requirement: grant the query permission of all tables of a user to another user. Authorization using oracle learning records (1) Table-by-table authorization is

A bug of oracle-rdbms-server-11gR2-preinstall solved Oracle provides a very convenient Kernel Parameter Modification RPM package, indeed saves a lot of trouble, especially after the script, only need www.2cto.com cd/etc/yum. repo. d/wget

View the NLS_LANG method view the NLS_LANG method Windows use: www.2cto.com echo % NLS_LANG % E: \> echo % NLS_LANG % AMERICAN_AMERICA.ZHS16GBKUnix use: env | grep NLS_LANG such: /opt/oracle> env | grep NLS_LANGNLS_LANG =

Oracle restores accidentally deleted data table records. If no truncate statement exists, you can choose to recover the table records based on the transaction commit time. The general steps are as follows: www.2cto.com 1. First query from the

Today, I was counting a piece of data at work. At first, the SQL statement was successfully executed, but then the user adjusted the requirements slightly. I thought it would be possible to add a query condition, the result is generated after more

Use DBMS_FILE_TRANSFER to migrate tablespaces and data files in ASM. This is a stored procedure package and a toolkit for executing migration tasks besides RMAN,You can complete the following migration: ASM-> ASM, ASM-> OS Flie, OS File-> ASM, OS

OCP question analysis _ 007: sequence can be designed to be unique, but continuous instances cannot be implemented. sequence disconnection number, transaction rollback, sequence disconnection number, concurrent access, sequence may be disconnected ..