Oracle

1. Give one method for transferring a table from the schema to another:There is several possible methods, Export-import, CREATE TABLE ... As SELECT, or COPY.2. What is the purpose of the IMPORT option IGNORE? What is it?s default settingThe Import

There are two ways that Oracle can interact: Sqlplus (command line) SQLPLUSW (graphical interface)Enter Sqlplus mode: cmd input sqlplusEnter SQLPLUSW mode: cmd input SQLPLUSWMore convenient way: Winkey + R Open the Run window--Enter Sqlplus or

This article is an original article,Reprint please indicate the sourcehttp://blog.csdn.net/msdnchina/article/details/41413313To delete an archive log, you need to confirm several points in advance:1. Whether it is a DG environment: if the DG

When installing Oracle, you need to adjust the kernel parameters of Linux , but what do the parameters mean?Minimum values given in the Linux installation documentation:FS.AIO-MAX-NR = 1048576Fs.file-max = 6815744Kernel.shmall = 2097152Kernel.shmmax

The steps for Oracle to modify the table space that the user table belongs to are modified using scripts. As far as we know, it is necessary to modify the length ofthe space of the tableAndThe index space of the table, if it involves the table of

i do not have much time to use Oracle, but I have accumulated some lessons in the project to make it easier for me and others to solve similar problems. 1.temp space exceeds the limit problemProblem Scenario:in the complex ETL query, sometimes a

1. In Oracle, the stored procedure consists of three parts: the definition section, the execution section, and the Exception handling section (that is, the exception)EG1: Enter the employee number to inquire about the employee's name and

The growth strategy for setting the ID is sequence, specifying sequence's name, preferably one for each table sequenceFor example, create a sequence:CREATE SEQUENCE department_id_seq MINVALUE 10000 MAXVALUE 999999999999999999999999 INCREMENT by 1

Original sql:Select substr (field1, InStr (field1, ' | ', 1, rownum) + 1, InStr (field1, ' | ', 1, rownum + 1)- InStr (field1, ' | ') , 1, RowNum)-1) as Field2 from (select ' | ' | | ' A|bbb|cccc|ddddd|ee|d|a '

Failure phenomena:Sql> Connect Scott/scottERROR:Ora-01017:invalid Username/password; Logon deniedSql> Connect Scott/scottERROR:Ora-28000:the account is lockedIndicates that the Scott user in Oracle was locked after 10 times because of the wrong

Check the salary of each department in 25%, 50%, 75% position,Percent_rank () is the relative position in the ranking .CREATE TABLE EMP(EMPNO Number (4) is not NULL,Ename VARCHAR2 (10),JOB VARCHAR2 (9),MGR Number (4),HireDate DATE,SAL number

Oracle RAC Study--delete vote DISKEnvironment:Operating System: AIX 5300-09Cluster Software: CRS 10.2.0.1Database: Oracle 10.2.0.1There are two ways in which RAC can be used to build an AIX platform based on shared storage:1. Establish shared

NVL () function in OracleOracle's use of the NVL functionThe total value of a field is obtained by a query, and if the value bit is NULL, a default value is given.Select NVL (SUM (T.DWXHL), 1) from Tb_jhde t where zydm=-1Here the usage of the NVL is

--==================================== Stored Procedure ===============================================/**scm_iss.test_imit_ pro1* no parameter stored procedure */create OR REPLACE PROCEDURE Test_imit_pro1 as P_imti_name VARCHAR2 (200); X_message

Windows Edition: Official website download, two compressed package, a total of 2G, extracted to the same folder, Setup.exe double-click to execute, waiting for the good, general performance of the machine about half an hour or so. After installation,

Oracle Database Connection detection (Shell)Version 1 Oracle Database Version: Oracle Release 10.2.0.1.0 System Version: Red Hat guest iselinux 5.4  2 Check Step 2.1 write Shell scripts Edit the check_oracle_connection.sh script for a user with

About Oracle Database Shutdown I have talked about Oracle Database startup before. Let's talk about Oracle Database shutdown today. I. Three Phases of database ShutdownThe Oracle Database startup process involves three steps: NOMOUNT-> MOUNT-> OPEN.

DBA_Oracle Archive Log basic application and enabling (concept), dba_oraclearchive BaoXinjian I. Summary Archive logs are backups of redo logs. Archive logs are used for media recovery. Log Operation Mode 1. Noarchivelog (non-archive Mode) Do not

Summary of methods for detecting ORACLE data block corruption 1: Use initialization parameters You can use the initialization parameter db_block_checksum \ db_block_checking to set the database's physical consistency and logical consistency check

Oracle _ view Oracle _ view ① View1. A view is a virtual table.A view is built on an existing table. The tables created by the view are called base tables.The statement that provides data to the view is a SELECT statement, which can be understood as