Oracle

1. Export the database instance:operate under the cmd command:Exp database user name/password @ server ip:1521/ Example file=c:\devdb.dmp full=y2. Import the database instance:Create the related database, set up the related table space + user +

Original source: Little BMW's father-the dream homeIn front of, but also intermittently introduced some such as sql*plus and so on Oracle's basic content,For a large database such as Oracle, its own operation and maintenance is also a great thing,So

The recent systematic study of Oracle SQL statement Performance Tuning has come to the conclusion that many performance tuning on the web is wrong or not comprehensive.Now the DBA Daniel are too low-key, not come out treatise, the younger brother to

Function: Used to return specific data, functions can be executed directly in the SQL statement, including return for data manipulation, and return a separate function valueStored procedures: Used to complete a specific task (business of the program)

Common functions:• Statistics: Count (), returns the result based on the actual amount of data in the table;• Sum: Sum (), which is a statistic for numbers, sums• Average: Avg (), various data types support• Max: Max (), various data types support•

1, if the number of Oracle connections to reach the upper limit, using Plsql to connect to Oracle, there will be no connection error, typical errors are:Maximum number of processes (exceeded)2. Restart the Linux machine (otherwise not connected),

In the recent work has encountered the production Environment database table was deleted, in fact, such things should not have happened.A few small suggestions: Production environment database developers can only have query permissions,

Oracle implicit parameter modification and viewingAlter system set "_allow_resetlogs_corruption" =false scope=spfile sid= ' * ';Col name for A30;Col value for A10;SelectX.KSPPINM name,Y.KSPPSTVL value,Y.KSPPSTDF IsDefault,Decode (Bitand (y.ksppstvf,7

SQL Code--Delete empty tablespace, but no physical fileDrop Tablespace tablespace_name;--Delete non-empty table spaces, but not physical filesDrop tablespace tablespace_name including contents;--Delete empty table space, including physical filesDrop

A stored procedure is called with Oracle's job, such as a stored procedure that is trapped in a dead loop or other cause, and the status of the job is always running. At this point, the stored procedure is called manually, and the stored procedure

The Oracle tutorial you are looking at is: Renaming the foreign key for Oracle system tables.The foreign key of a table in Oracle is a means of guaranteeing system referential integrity, whereas referential integrity refers to a constraint

AWR reportThe AWR report is a performance collection and analysis tool provided by Oracle 10g and above that provides a report of the overall system resource usage over a period of time, through which we can understand the entire operation of the

--Current Date Select To_char (add_months (sysdate, 0), ' yyyy-mm-dd ') Pretoday from dual--last month current date select To_char (Add_months (sysdat E,-1), ' Yyyy-mm-dd ') Pretoday from dual--next month current date SELECT To_char (Add_months

PQL Parameters ORACLE Account------------------        -------------------------PQL_MASTLM = ASTLM = 1000Pql_mbiolm = Biolm = 1000PQL_MBYTLM = 1000000 BYTLM = 2000000Pql_mdiolm = Diolm = 1000Pql_mpgflquo = 2000000 Pgflquo = 2000000PQL_MPRCLM = PRCLM

= = <> (not equals)! = (Not equal to): = (Assignment)Between......and (contains boundaries in an interval)--Query wages from 2000 to 5000 of the salary select salary from employees where salary between2000and5000In ()--Query 80,90,70,50, department

The latest database space has a feeling catch urgent, last time, deleted some data empty 800+g, one months, and now there are 400+g, 10G per day increments, how much space also feel not enough ah.Cannot add the hard disk, only then deletes the

Triggera database trigger is a table-associated, storedPL/SQLprogram. Whenever a specific data manipulation statement(Insert,update,delete)when emitted on a specified table, theOracleautomatically executes the sequence of statements defined in the

--Create TABLE space permissionsGrant Create tablespace to QJT--Delete Table space permissionsGrant DROP tablespace to QJT--Create TABLE spaceCreate Tablespace QjttestDataFile ' F:\app\QiuShao\oradata\orcl\qjt_1.dbf ' size 10m,'

--Range Partitioning--Build a tableCREATE TABLE Orders(ORDER_ID Number (12),Order_date date NOT NULL,Order_total Number (8,2))Partition by RANGE (order_date)(Partition P1 VALUES less than (to_date (' 2015-01-01 ', ' yyyy-mm-dd ')),Partition P2

Column SQLText format A80Select COUNT (*) from dba_segments where tablespace_name = ' USERS ' and segment_type= ' TABLE ';Select ' ALTER TABLE ' | | Owner | | '. ' | | Segment_name | | ' Move tablespace dbs_temp; ' SQLText from dba_segments where