Oracle

--Create sequence Create sequence Innerid minvalue 1 maxvalue 99999999999999 start with 1 increment by 1 cache order;2.--innerid.currval refers to the current sequence--innerid.nextval refers to the next sequenceCREATE TABLE admin (ID varchar2 (),

Description of the phenomenon:Statistics Server Test No problem, just the last time to configure the system a bit of a problem, so re-install, configuration good Safety strategy (recently on how to configure a new Server , the first time to

Oracle Action Table "Resource is busy, need to specify nowait" method of unlockingProblem:When executing drop table table_name, the prompt "resource is busy, you need to specify NoWait"PL/SQL is not responding due to a problem that can only be

/** *  Execute Stored procedure (currently only supports returning one cursor)  never null *  *  @param  sql *              executed statements  *  @param  index *              subscript of the current cursor  *  @param  obj  *            

Today on the oracle11g with the EXP command to export when encountered a strange phenomenon, no data table exp is always not out, the query found this is a new feature of Oracle 11g, when the table has no data, do not allocate segment, to save space.

Solaris (x86) Build Oracle 10g RAC--Install CRSSystem environment:Operating system: Solaris ten (X86-64)Cluster:oracle CRS 10.2.0.1.0Oracle:oracle 10.2.0.1.0: RAC System Architecture650) this.width=650; "src="

============================================= successfully installed the database =======================================================1. If you have two files when installing the database, you need to merge the two files before installingAfter

By default, user A in Oracle needs to access User B's table with a prefix of User B, such as access to User B's Users table, which is required to access select * from B.user; If you want to add a user prefix, you need to do this:1. Use the view to

Environment: Oracle 10g for AIX systemsTSM5.4IBM with Library LIB3584Cause of the problem:After migrating the database, after redeploying the TSM BA client and turning on the DSMC schedule process in the operating system where the new database

Demand:Match the phone number, the first bit can be +, can not +, the back of all if the number, such as:+86135941566586136595585551356856455are legal.+aa156945555aa1359556666Aaddssdfdfsdare not legal.Regular:[SQL]View Plaincopyprint? Sql>

1. Disable Oracle Services: Enter Computer Management, in the service, find all services at the beginning of Oracle, right click to select Stop2. In the Start menu, locate Universal Installer, run Oracle Universal Installer, click Uninstall product3.

The DML error log is a sql*loader-like error logging feature introduced by ORACLE10GR2. The rationale for this is to transfer any records that might cause the statement to fail and put them in an error log table.The specific use is as follows:1, use

ERP System Form query interface could not be opened, the reason:ERP db rollback space is insufficient, resulting in the system DB does not have enough space to support form query operation;Solution:1, check erpdb1 and ERPDB2 log information content:

Linux Environment configurationOs:centos 6.6Db:oracle 11gR2Installing Oracle into the Home/oracle directoryConfiguration process: This article is from Oracle official documents + Online materialsOracle Official Document: Http://www.oracle.com/pls/db1

Organize your own commands that are common in Oracle:ORACLE11G has not supported Isqlplus anymore. Built-in Oracle SQL developer1-----User Multiple Login error, Locked:ALTER USER username account UNLOCK;2-----Modify User password:alter user system

Oracle Database creates and uses memory structures for various purposes. For example, memoryStores program code being run, data, was shared among users, and private data areas for eachConnected user.Both basic memory structures is associated with an

Resizing swap partitionsMethod One: If the disk has the remaining space, use the partition tool to create a new swap partition. and write to/etc/fstab inside.Again #swapon-AMethod Two: You can use a file to do the swap partition.Su RootCD/Mkdir/swap1

Life, easy to forget the Oracle database system user password, how to do it, niche take you step by step back to Oracle, timely your password forgotten.1. Open cmd window, enter Sqlplus/as SYSDBA2, run CMD, enter the ALTER user username account

Original: Oracle Base database backup and RecoveryFirst, why need data backupThe main reasons for data loss:1, media failure.2, the user's error operation.3, the server's complete collapse.4, computer viruses.5. Unforeseen factors.The fault types in

OracleEBSR12.2 create a custom Module The following steps describe how to register a custom module in EBS R12.2. Refer to Oracle support Creating a CustomApplication in Oracle E-Business Suite Release 12.2 (Document ID 1577707.1)   1. Download patch