Oracle

ALTER tablespace xh_dm DROP datafile ' F:\DEV\ORACLE-DATA\ORCL\XH_DM_1.DBF ';sql> ALTER tablespace XH_DM2 DROP datafile ' F:\DEV\ORACLE-DATA\ORCL\XH_DM_1.DBF ';ALTER tablespace XH_DM*ERROR at line 1:Ora-03262:the file is Non-empty1 --Oracle Storage

Summarizes the Oracle exceptions and handling methods that are often encountered when working with databases. Code Tips NoteGeneral processing methods ORA-01861 The text does not match the format string-

Col_2 Col_321 3123 31As above table dataFront desk display shows the need to convert col_2 21 and 23 into Chinese ' machine ' starting with the following writingSELECT T.col_3,Case T.col_2WhenMachineWhenMachineENDFrom A_test_1 tGROUP by

1. General insert operation.　　Use syntax insert INTO table_name[(Column[,column ...])] VALUES (Value[,value ...]) Insert statement, each insert can only be inserted into one of the specified data in the target table. If there are many rows that need

In Oracle's initial experience, the installation of Oracle was completed, but no DB instance was created and the listener was created, and in this article I will completeCreate a DB instance------------------------------------------------------------

The database instance was created in the previous installment, but there was a problem when the DB instance was last accessed with EM?Enterprise Manager cannot connect to the DB instance. The status of the components is listed below.To answer the

Sixth Zhang Ziyi ( Enquiry1. Sub-query syntax:SELECTselect_listFromtableWHEREexpr operator (SELECTselect_listFromtable);A subquery (inner query) executes one time before the main query.The results of the subquery are used by the main query

First, related foldersOracle_base is the root of Oracle, and Oracle_home is the catalog for Oracle products. Under Oracle_base is admin and product.Oracle_home is the Oracle command, connection library, installation assistant, L monitoring and so on

1. Basic SELECT Statement1. Basic SELECT StatementSelect identifies which columns are selected.From identifies the table from which to select.Attention:SQL language is not case sensitive.SQL can be written in one line or multiple linesKeywords

Symptom: Oracle Insert time, Error: ORA-01861: text does not match format stringWorkaround:This error usually occurs on the time field, that is, the time format you inserted is inconsistent with the existing time format of the database, and the

Starting a database instance is divided into two steps: The first step, start monitoring, and the second step, start the DB instance. I. How to start a DB instance 1. Go to Sqlplus launch instance [[email protected] ~]$ su-oracle--"Switch to Oracle

Plan tables and storage spaces to prevent space shortages or wasted space Plan for a quick recovery zone, define the fast recovery zone in a different storage area from the data file, reducing IO contention Name of the planning

1> the custom comparison function, the value of Targetval is a string, for example: ">=90", "2~8", and so on, the Dataval value is a string.Create or Replace functionCompare1 (Targetvalinch varchar2, Datavalinch varchar2)return integer

Three frequently used users after a newly installed OracleUser: System Password: When the manager is created, a change password can also be modified,User: Sys Password: changr_on_installUser: Scott Password: TigerThere are three tables under user

One: The gentle way:1, view all job;SELECT * from Dba_jobs;2, check the running job;SELECT * from Dba_jobs_running;3, according to SID isolated the corresponding session;Select sid,serial# from v$session where sid= ' &sid ';4, kill the corresponding

Fourth Multi-table query1. Descartes SetThe Cartesian assembly is produced under the following conditions:Omit join conditionInvalid connection conditionAll rows in all tables are connected to each otherTo avoid a Cartesian set, a valid join

1. Cartesian product Merge Join CartesionSql> select Ename,dname from Emp,dept;56 rows have been selected.Execution plan----------------------------------------------------------Plan Hash value:2034389985----------------------------------------------

Oracle Storage in Action: Delete physical data files, oraclestorage Alter tablespace XH_DM drop datafile 'f: \ DEV \ ORACLE-DATA \ ORCL \ XH_DM_1.DBF '; SQL> ALTER TABLESPACE XH_DM2 drop datafile 'f: \ DEV \ ORACLE-DATA \ ORCL \ xh_dm_1.dbf

Oracle-force stop jobI. gentle approach:1. view all jobs;Select * from dba_jobs;2. view the running job;Select * from dba_jobs_running;3. Find the corresponding session based on the sid;Select SID, SERIAL # from V $ Session where SID = '& SID ';4.

Oracle11g manual steps #create oracle instance parametervi initkevin.ordb_name='kevin'memory_target=0sga_max_size=5Gsga_target=3Gpga_aggregate_target=1gprocesses = 150audit_file_dest='/u01/app/oracle/admin/kevin/adump'audit_trail ='db'db_block_size=8