Oracle

The Oracle database can run in 2 modes: Archive Mode (Archivelog) Archiving mode can improve the recoverability of Oracle database, the production database should run in this mode, the archiving mode should be combined with the

1.Grant Row Migration PermissionsALTER TABLE table_name enable row movement;2.To 15 minutes ago:Flashback table order to timestamp systimestamp-interval ' minute;To a point in time:FLASHBACK TABLE order to TIMESTAMP To_timestamp (' 2017-06-12 01:15:2

--Create the user create user XX identified by "", default tablespace USERS temporary tablespace TEMP profile default Password expire;--grant/revoke role privileges Grant connect to Xx;grant Ctxapp to Xx;grant dba to Xx;grant exp_full_database to xx;

1. Create a database directory2. Copy the Pfile file from the original host and change the ORACLE_SIDVi. Bash_profilesource. Bash_profile3. Start data to Nomount status$ sqlplus/as sysdbasql> startup nomount pfile= ' pfile file absolute location ';

Oracle Basic data types (also called built-in data types built-in datatypes) can be categorized by type: String type, Number type, date type, LOB type, LONG raw& RAW type, ROWID & urowid type.Before Apple told the string type, let's talk about

Oracle Flashback is a fast and easy database recovery technology, it does not use backup files, through the flashback log can restore the database to a state of the past, when the user logic error (delete table data, table, table space, etc.) need

1. Query the profile information: SELECT * from SYS. Dba_profiles;SELECT * from SYS. Dba_profiles where profile= ' DEFAULT ';2.An example of creating a profile:1. CREATE profile "TEST"2. LIMIT3. Cpu_per_session 10004. Cpu_per_call 60005.

Crontab timed task trigger with Linux. The implementation process is as follows:First, sign in with an Oracle accountSecond, add the xxxxx.sh script under the/home/oracle directory.Content: Export oracle_sid=xxxxxExport

Management SectionIf database force logging is not enabled, the repository/*+ append */operation, nologging operation, will report the bad block;Suggested table space Force logging or database force logging;Test:Select Force_logging, tablespace_name

SymptomsWhen you create a database with DBCA, the full number of parameters is set to complete. Run to 2% when you start loading error ORA-01034 ORACLE not available,For example withwatermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqveglhb2zhbjizeg==/font/5

We use Oracle's own table for exampleTwo main tables: dept, EMPOne is the department, one is the employee table structure is as follows: emp name null? Type Empno NOT null

First, connect the database1, start Sql*plus, but do not log insqlplus/nolog 2. Connect to Oracle with SYSDBA role Connect Username/password as Sysdba (provided the user has SYSDBA privileges)3, direct connection with the SYS user l

Select ID from the group by ID have count (*) > 1Grouped by ID and counted, an ID number that has more than 1 of the group is considered duplicates.How to query for duplicate dataSelect field 1, Field 2,count (*) from table name Group By field 1,

Create Dblink between Oracle and Oracle1. Create:CREATE [public] DATABASE LINK Custom dblink name to by '(DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (host = destination hostname) (PORT = 1521)) (connect_ DATA = (service_name =

Oracle provides 22 different types of SQL data for our use:1, Char:This is a fixed-length string that is padded with spaces to reach its maximum length. The Char field can store up to 2000 bytes of information;2, nchar:This is a fixed-length string

In peacetime to do backup of Oracle is usually to do a logical hot backup, and do a logical hot backup is generally used Exp/imp, here is simple to say.Export Data using EXP IMP import data operation as follows:Exp Username/password owner=backup

---- First step: Set up empty table export----The empty table cannot be exported because Oracle 11G is exported with export. The workaround is as follows: (There is a new feature in 11G that does not allocate segment to save space when the table has

http://blog.csdn.net/cselmu9/article/details/8070728/Due to the continuous updating of hardware technology, Win7 system gradually become mainstream, and computer memory gradually increased, in order to make full use of memory resources (because 32

I. Using a FOR loop cursor: Traverse all positions as manager's employees1. Define a cursor (a cursor is a small collection)2. Defining cursor Variables3. Using a For loop cursorDeclare --Define cursor c_job cursor c_job is select Empno, ename,

Background: A sign in Oracle changed to SQL ServerWorkaround:1, first think of Microsoft's solution:Microsoft SQL Server Migration Assistant v7.4 for Oraclehttps://www.microsoft.com/en-us/download/details.aspx?id=54258According to the introduction