Oracle

Every time is silly to BASHRC inside write environment variable, feel not wayward. So, after reading this book to understand/etc/oratab this east, refer to the book also wrote a script to set the Oracle environment variable.Create Oraset under/etc/,

References organized from: http://docs.oracle.com/cd/B19306_01/network.102/b14266/admusers.htm#i1006856Just pick dry words!!!One user management1. Create userCreate user DylanIdentified by 123Default Tablespace users--Specify table spaceQuota 100m

Grammar:SELECT * FROM Some_table[Where Condition 1]Connect by [Condition 2]Start with [condition 3];The order in which the connect by and start with statements is placed does not affect the results of the query, [WHERE Condition 1] may not be

The buffer sort in the Oracle execution plan is not actually sorted, just loading the data into memory and not scanning multiple tables.--Manufacturing datadrop table test Purge;drop table Test1 Purge;CREATE TABLE Test as SELECT * from Dba_objects

The benefit of the oracle10g Recycle Bin is that when a table is mistakenly deleted, there is a mechanism for recovery, but if you do not need to use this feature, you can use the command to close1. Turn off or turn on the Recycle Bin functionALTER

first, how to effectively use the data dictionary  Oracle's data dictionary is one of the most important parts of a database, which is generated as a result of the database, and changes as the database changes, reflecting some of the tables and

1-The SID of the imported database, if not definedExport Oracle_sid=database 2-Connect to the database with operating system authentication[Email protected] ~]$ sqlplus/as sysdbasql*plus:release 11.2.0.1.0 Production on Mon Dec 1 17:38:02

The current time is noon. You want to recover the USERS tablespaceFrom a failure this occurred at 11:50 a.m. You discover thatThe only member of Unarchived Redo log group containing informationFrom 11:40 a.m. onwards is corrupt.With reference to

SUBSTR (string, intercept start position, intercept length)//return intercepted wordsubstr (' Hello World ', 0, 1)//return result is ' H ' * start with a string of length 1 from the first charactersubstr (' Hello World ', 1, 1)//Returns the result

A couple of systems have finally succeeded with CentOS installation Oralce, and here I've also consulted a lot of information on the web as well as Oracle's official documentation1, download Oracle, I choose here is the 11GR2 version, download down

1, first, introduce the TO_CHAR functionTo_char is to convert a date or number to a string and cannot specify a string length.Use the TO_CHAR function to process the date:To_char (number, ' format ') For example: To_char (Salary, ' $99,999.99 ')Use

lower--Convert to lowercaseupper--Convert to uppercaseinitcap--First Letter Capitalconcat--Connection Characterssubstr--Intercept characterslength/length--Get string Length (bytes length)instr--where the specified character is locatedlpad/rpad--Left/

oracle10g start-Up and shutdown:OFF: Isqlplus and EM (isqlplus/em No close order, that one can be closed first)---> Monitoring---> DatabaseIsqlplus shutdown:NETSTAT-TULNP | grep 5560 See if the Isqlplus 5560 port is listening on Isqlplusctl stop

You are using Oracle Database 10g. The log Log_archive_format PARameter is set to ' log%t_%_s_%r.dbf '.Why are%r used in the file name format?A. To uniquely identify the archived log files with the restore operation.B. To uniquely identify the

Command:Sqlldr Userid=[username]/[password]@[database] Control=[filepath]Username User NamePassword PasswordDatabase DB InstanceFilePath the physical path of the CTL

Recently there is time to learn Oracle, the process of learning to organize out, the long learning path, now just start.1. #su-oracle2. Start monitoring$ lsnrctl Start3. Start EM$ emctl Start Dbconsolehttp://192.168.88.139:1158/em/4. Start Isql*plus$

In order for the PL/SQL function to return multiple rows of data, it must be done by returning a REF CURSOR or a data collection. This case of REF CURSOR is limited to the data that can be selected from the query, and the entire collection must be

Oracle deletes all objects (tables, views, triggers, stored procedures, and functions) of the current user) Incluincludeclaretype name_list is table of VARCHAR2 (40); TYPE type_list is table of VARCHAR2 (20); Tab_name name_list: = name_list (); Tab_

Oracle uses sqlldr (with sequence) to import data Command: Sqlldr userid = [USERNAME]/[PASSWORD] @ [DATABASE] control = [FILEPATH] Username Password Database instance Filepath: physical path of the ctl File ----------------------------------

How to solve the problem of migrating from non-archive mode to archive mode in Oracle Database I found several problems during the oracle archive test today. I will record them here for your suggestions and help. [oracle@localhost ~]$ sqlplus / as