Oracle

Oracle database table Space usage query:Select B.file_name Physical file name,B.tablespace_name table Space,b.bytes/1024/1024 size M,(B.bytes-sum (NVL (a.bytes,0)))/1024/1024 has used M,SUBSTR ((B.bytes-sum (NVL (a.bytes,0))/(b.bytes) *100,1,5)

It's been all the time. SQL Server suddenly with Oracle egg pain of the even stored procedures to execute a query will not be all kinds of Baidu now record the following syntax problemsOrcale The syntax for creating a stored procedure,Create or

This article mainly introduces the use of RowNum and Row_number () in Oracle, as well as the differences and links, very detailed, the need for small partners can refer to.Row_number () over (partition by col1 ORDER by col2) indicates that,

When we use the Oracle database, suddenly power outages, causing a lot of problems, resulting in the loss of old data, affecting the correctness of the data, destroying the database. At this point, users desperately need to recover data. This

View all user partition tables and partitioning policies (1, Level 2 partition tables are included):SELECT p.table_name as table name, decode (P.partitioning_key_count, 1, ' primary partition ') as partition type,P.partitioning_type as partition

1. Create a table in SYS mode that records the details of the client's login to the database serverCreate Tablelogon_logs (logon_time date,usernamevarchar2( -), machinevarchar2( -), Ipadrvarchar2( -), programvarchar2( -), modulevarchar2( -),

1. Create a table spaceCreate'/u01/oracle/oradata/orcl/yyy01.dbf' on Next 50m maxsize unlimitedextent Management local2. Create a userCreate User by yyy default tablespace yyy Temporary Temp DEFAULT3. User authorization--Grant/revoke Object

1. See if Oralce is an archive or non-archive modeSql> select Name,log_mode from V$database;NAME Log_mode---------------------------------------- ------------------------------------YOON ARCHIVELOGSql> select Name,log_mode from V$database;NAME

First check the Oracle parameters: Sql> Show Parameters SGA; NAME TYPE VALUE------------------------------------ ----------- -------LOCK_SGA Boolean TRUEPRE_PAGE_SGA Boolean TRUE If the value of the above two options is false, it needs to be

First step: Login After root login, switch to Oracle user, enter Su OracleStep Two: Connect Under Oracle user, enter Sqlplus/nologStep Three: Use Administrator privileges Input Connect/as SYSDBAFourth step: Start/Close service Input StartupStartup

1. The Start command is[Email protected] ~]$ CD $ORACLE _home/bin[Email protected] ~]$/emctl start dbconsoleStop command Yes[Email protected] ~]$./emctl Stop DbconsoleView OEM Status[Email protected] ~]$/emctl status DbconsoleOracle's environment

Set Linesize 132Column name format A30Column value Format A25SelectX.KSPPINM name,Y.KSPPSTVL value,Y.KSPPSTDF IsDefault,Decode (Bitand (y.ksppstvf,7), 1, ' MODIFIED ', 4, ' system_mod ', ' FALSE ') Ismod,Decode (Bitand (y.ksppstvf,2), 2, ' TRUE ', '

CREATE TABLEt_smaint_2016012703Parallel 4 nologging asSELECT /*+parallel (4) leading (s a) Use_hash (a) index (s idx_cs_service_record_md2_04)*/s.smaint_id, S.smaint_desc fromT_cs_service_record SJOINT_cd_maint A ona.smaint_id=s.smaint_id ands.sorg_

Sql> create Pfile from SPFile;Modify the Pfile file, add the implied parameter *._enable_rename_user= ' TRUE ' to start the database in restrict mode1, [[email protected] ~]$ cd/u01/app/oracle/product/11.2.0/db1/dbs/2, [[email protected] dbs]$

1 　　 Public Static voidMain (string[] args)throwsSQLException {223344 String driver= "Oracle.jdbc.driver.OracleDriver";55 String url= "Jdbc:oracle:thin: @www. Ee.w.www:1521:orcl"; 66 String user= "RRR"; 77 String password= "RRR";8899 Connection

1. CMD on the Oracle serverExecutive LsnrctlExecute startAfter a long time, the prompt listener has been started.Perform status againIt was a long time before the command was executed successfully.It is best to find the cause because the

Occurs when debugging an Oracle Query statement: Column 650 not explicitly defined this.width=650; "src=" http://s1.51cto.com/wyfs02/M01/7A/48/ Wkiom1am4hfxggskaab9ne12vws774.png "title=" Oracle undefined column. png "alt="

Export and import a specified table from Oracle Export from source database: Exp user1/pwd @ server1 file = c: \ temp \ exp. dmp tables = (table1, table2) Import to the target database: Exp user2/pwd @ server2 file = c: \ temp \ exp. dmp tables =

Basic methods for creating indexes in Oracle databases, oracle Indexes How to create the best index? 1. Create an index explicitly create index index_name on table_name(field_name)tablespace tablespace_namepctfree 5initrans 2maxtrans

Oracle learning database data is saved as a file, oracle Database It is often necessary to generate documents from the data in the database. Because you prefer the script method, you need to set the format when using spool, the following is a simple