Oracle

The database and the client are on different machines.Before installing, navigate to the following folder on the server where the Oracle database is installed.Change localhost in Listener.ora and Tnsnames.ora to the IP address of the machine, my 192.

Legend: The following parameter name abbreviations are used in this diagram:MT = Memory_targetMMT = Memory_max_targetST = Sga_targetPAT = Pga_aggregate_targetSMS = Sga_max_sizeWhen Memory_target is set to a value other than 0:If Sga_target and

The drop tables and indexes are stored in the Recycle bin ( so the Recycle Bin function must be set for the production database )Because this generation environment after dropping the existing table, re-create a lot of tables, all the direct

[Turn]http://www.cnblogs.com/linjiqin/archive/2012/01/16/2323320.htmlFirst, when establishing the table, pay attention to the role of pctfree parametersPCTFREE: The percentage of space reserved for a block, indicating when the data block can be

Invalid when querying against incoming parameters in Oracle stored procedureEnvironment: oracle11gRequirements: Query the relevant data based on the parameters passed in as criteriaProblem: Invalid conditionCode:Create or Replace procedure XXX

--Confirm Current CDB Sql> select name,cdb from V$database; NAME CDB------------------------ORCL YES --Query the current PDB basic information Col pdb_name for A30select Pdb_id,pdb_name,dbid,status,creation_scn from Dba_pdbs;select

Because Oracle has a slightly different format for adding and deleting columns, it is hereby documented for easy viewing later.1. Add Columns:Sql> ALTER TABLE t1 add y integer;Table AlteredExecuted in 0.046 secondsDescription: Added column format

Create table spaces and user names/* Step 1th: Create a data table space */Create Tablespace FLXLoggingDataFile ' E:\oracle\product\10.2.0\oradata\orcl\flx.dbf 'Size 50mAutoextend onNext 50m maxsize 20480mExtent management Local;/* 2nd step: Create

Oracle Automatic Memory parameter dependency The database will only automatically optimize the size of the child components of SGA. The Automatic Optimization of PGA is irrelevant to whether or not to explicitly set the PAG. However, the overall

Oracle block damage and recovery 1. What is block damage: Damaged data blocks refer to data blocks that are not in identifiable Oracle format or are inconsistent internally. In general, damage is caused by hardware faults or operating system

Oracle job process solves the problem of no automatic execution It's easy to create a job. Here we mainly talk about the problem that the job is not automatically executed according to the specified time.Solution: 1. Run the job Begin

How can I retrieve the password entered by the system user of oralce? Met the ORA-28000: how to unlock theaccountislocked? The Oracle software installed a few months ago suddenly forgot the password you set. Today, I checked how to retrieve it.

Oracle Database Export and Import You need to export the data in database A to the *. dmp file, and then import the *. dmp file to database B.1. Export Database A. Enter the following command in the cmd window: Export all databases Exp username/

Oracle database backup and recovery (expdp and impdp) Reference: http://blog.csdn.net/oraclemch/article/details/5551634 Oracle 11g beginner's Guide Http://www.cnblogs.com/netsql/articles/1745978.html The materials on the Internet are fragmented, and

Plsql_performance optimization series 13_Oracle Index Rebuild Index reconstruction, plsql13_oracle 2014-10-04 BaoXinjian I. Summary Index rebuilding is a topic that is constantly under discussion. Of course, Oracle also has its own opinions. Many

Oracle flash back table experiment Job: flashback table experiment 1. Construct the flb_test table, with no less than 10000 rows of data; TEST_USER1 @ PROD> create table flb_test (id number, dd date ); Table created. TEST_USER1 @ PROD> begin2 for I

Single-row functions of oracle reinforcement exercises 1. dname AND loc are separated- Select dname | '-' | loc From dept; 2. Fill the team name with 10 digits left Select lpad (dname, 10) From dept; 3. Replace the employee's name' Select replace

Adjust the size of redologfile in oracleracAdjust the size of the redo log file under rac(1) view the current log information:Select * from v $ logfile;(The path in step 2 can be seen in the MEMBER column here. The redo file name is named by

Spoon kettle fails to connect to the database. Solution: spoonkettle Driver class 'oracle. jdbc. driver. OracleDriver 'could not be found, make sure the 'oracle' driver (jar file) is installed.Oracle. jdbc. driver. OracleDriver I just downloaded

PL/SQL -- triggers and plsql triggers I. IntroductionThe trigger is stored as an independent object in the database. Unlike the stored procedure and function, the stored procedure and function must be displayed and called before execution, A trigger