Oracle

#!/bin/shExport oracle_base=/app/oracle/Export Oracle_home=/app/oracle/productExport path= $ORACLE _home/bin: $HOME/bin: $PATHExport Oracle_owner=oracleExport ORACLE_SID=ORCL#数据库备份存放目录#BACKUP_DIR

The following is an example of importing and exporting.Data export:1 full export of database test, user Name System Password Manager exported to D:\daochu.dmpExp system/[email protected] file=d:\daochu.dmp full=y2 Exporting the system user in the

1. View processes and Sessions parameterssql> Show parameter ProcessesNAME TYPE VALUEdb_writer_processes integer 1gcs_server_processes integer 0job_queue_processes integerlog_archive_max_processes integer 2processes integersql> Show Parameter

To delete a failed materialized view today; the manager said it was a lock watch; then Baidu took a look.Here is the query lock table and how to unlock it--Query the lock nowSELECT l.session_id Sid, S.serial#,

[SQL]View Plaincopy To establish the tablespace and the user's steps: User Create:Create user username identified by "password"; Authorization:Grant create session to user name; Grant create table to user name; Grant create

Max Maximum number auto plus 1Create or Replace function Fun_getmaxlot ( vend in varchar2, domain in VARCHAR2, tag in varchar2) RETURN Varch AR2 as maxval VARCHAR2 (40); NEWIQC VARCHAR2 (40); TT VARCHAR2 (12);

Sql> CREATE TABLE Test (ID number,name varchar2 (Ten), Gender VARCHAR2 (5)); sql> INSERT INTO test values (1, ' Song Chunli ', ' Male '); 1 rows have been created. sql> INSERT INTO test values (2, ' ye min paid ', ' Male '); 1 rows have been created.

In Oracle we know that there is a hierarchical Queries with connect by we can conveniently check all the child nodes under all current nodes. Unfortunately, there is no corresponding feature in the current version of MySQL.In MySQL if it is a finite

Oracle---------------------------------------SELECT case when T.column_id=1 and T.table_name end table_name, case if T.column_id=1 then T2.comments end Table_ Comments, t.column_id,t.column_name,t1.comments,case when T3. COLUMN_NAME is isn't null

Original:Http://tech.it168.com/oldarticle/2006-04-02/200604021512359.shtmlHttp://www.cnblogs.com/m-cnblogs/archive/2012/02/23/2364906.html1. Create a test stored procedure:sql> Create or Replace procedure Proc_test (P1 in varchar2,p2 off varchar2)

1. There are four fields in the table: Personnel number, start time, end time, type, data ID, need to implement the following requirementsA. When the type is-1, the record is discardedB. When the type is-1, and the previous line end time is null,

SQL Performance Tuning daily accumulation and SQL tuning Accumulation 1. Differences between Select Count (*) and Select Count (1: Generally, the returned results are the same for Select Count (*) and Select Count (1 ).   If the table does not

Common Oracle errors and common oracle errors 1. java. SQL. SQLException: ORA-01000: exceeds the maximum number of opened cursors Step 1:View the current number of cursors of the database. Configure slqplus: show parameter open_cursors; Step 2:View

Node eviction caused by heartbeat Network (not instance eviction) Node eviction of Oracle RAC caused by heartbeat Network (not instance eviction) Q:Suppose the following scenario: for the four node rac, the heartbeat line uses a m network

Oracle obtains the year, month, and date list for a certain period of time. Get date list: SELECT TO_CHAR (TO_DATE ('2017-10-01 ', 'yyyy-MM-dd') + ROWNUM-1, 'yyyymmdd ') as daylist from dualconnect by rownum Obtain the month list: SELECT

Oracle Learning (13): Data DictionaryThe data dictionary structure includes:-basic table: Description of database information, which can only be modified by the database server-User table: User-Defined tableData Dictionary naming rules

Implementation of SQL statements for ORACLE database-based cyclic table creation and cyclic storage Creation I. OverviewIn actual software development projects, we often encounter the need to create multiple database tables or stored procedures of

Oracle regular backup and oracle backup 1. Copy the following code to the text, and modify the text suffix name to a XXX. bat batch file; **************************************** **************************************** ******************************

Oracle BASICS (4): Single Table query1. Basic Query(1) Basic Statement 1. SyntaxSelect [distinct] * | {Column name...} from table name [where {condition}] 2. Note 1) distinct: whether to remove duplicate data when displaying resultsIndicates that

Application structure of Oracle Database Application structure of Oracle Database With the development of network technology, Oracle databases have been widely used in various fields. The application system structure based on Oracle databases mainly