oracle commands

1. Primary Key and foreign keyPrimary Key: a record in a relational database has several attributes. If one attribute group (note that it is a group, it can be one or multiple), it can uniquely identify one record, the attribute group is the primary key.Foreign key: a combination of one or more columns in a relational database table. Its value matches one or more columns in another table, it is the primary key of another table (that is, one or more columns of this table are the primary keys of a

, status;　　8 , view the version of the database Select version from Product_component_versionWhere SUBSTR (product,1,6) = ' Oracle ';　　9 , view the date the database was created, and how to archive it Select Created, Log_mode, Log_mode from V$database;III. Management of Oracle user connections1, with the system administrator, to view the current database has several user connections:Sql> select username,sid

1. su-oracle is not required. It is suitable for use without a DBA password. You do not need a password to enter the sqlplus interface.2. sqlplus/nolog, sqlplus system/manager, or./sqlplus system/manager @ ora9i;3. SQL> connect/as sysdba; (as sysoper) orConnect internal/oracle as sysdba; (scott/tiger)Conn sys/change_on_install as sysdba;4. SQL> startup; start the database instance5. view all current databas

Quickly create a user to import data Sqlplus/nolog Conn/As sysdba; Drop user Feiyang cascade; Create user Feiyang identified by Feiyang; Grant create session to Feiyang; Grant resource, connect, DBA to Feiyang; Conn Feiyang/Feiyang; Select table_name from user_tables; IMP Feiyang/Feiyang @ oraclefile = D: \ Feiyang. dmp full = y; Exp Feiyang/Feiyang @ oraclefile = D: \ Feiyang. dmp owner = (Feiyang ); Login: Sqlplus/nolog Conn apps/apps as sysdba Alter user Scott identified by tiger; Alter u

1. Su-Oracle is not required. It is suitable for use without a DBA password. You do not need a password to enter the sqlplus interface. 2. sqlplus/nolog, sqlplus system/manager, or./sqlplus system/manager @ ora9i; 3. SQL> connect/As sysdba; (as sysoper) or Connect internal/Oracle AS sysdba; (Scott/TIGER) Conn sys/change_on_install as sysdba; 4. SQL> startup; start the database instance 5. view

dump file. The default name is expdat. dmp.DUMPFILE = [directory_object:] file_name [,…]Directory_object is used to specify the DIRECTORY object name, And file_name is used to specify the dump file name. Note that if directory_object is not specified, the export tool automatically uses the DIRECTORY object specified by the DIRECTORY option.Expdp zftang/zftang @ zftang directory = dmp dumpfile = test1.dmp Steps for Data Pump tool export:1. create DIRECTORYCreate directory dir_dp as 'd:/

'; 1 PGA Summary2 SGA Abstract4 UGA Summary8 Current call (CGA) Abstract16 User call (CGA) Abstract32 Large call (LGA) Abstract1025 PGA content2050 SGA content4100 UGA content8200 Current call content16400 User call content32800 Large call content 7). Sub Heap Before Oracle 9.0.1 Alter session set events 'immediate trace name heapdump_addr level n '; If n is the subheap address, the digest information of the subheap is dumped.If n is the subheap addr

Create a data table space: Create tablespace test_dataLoggingDatafile 'e:/Oracle/product/10.2.0/oradata/testserver/test_data01.dbf'Size 32 mAutoextend onNext 32 m maxsize 2048 mExtent management local; Create a user and specify the tablespace: Create User Username identified by passwordDefault tablespace test_dataTemporary tablespace test_temp;// The last line does not seem to need to be used. I don't know if it will affect future use. Gran

files are located, Directory=directory_object Directory_object is used to specify the directory object name. Note that directory objects are objects created using the Create DIRECTORY statement, not the OS directory. EXPDP Scott/tiger Directory=dump Dumpfile=a.dump First create a physical folder in the corresponding location, such as D:/backup Create a directory: Create or replace directory backup as '/opt/oracle/utl_file ' Sql>create DIRECTORY

Oracle user is a database object, the user all operations by default in their own mode, the schema is a user owned database objects collection, each user has his own mode, the user and the mode is one by one corresponding to the pattern of the same name as the user name. For example, the Scott user's mode is Scott, which contains all the database objects that the user Scott owns, including tables, views, indexes, stored programs, and so on. The user's

This article introduces how to import and export elasticsearch. For more information, see. This article introduces how to import and export elasticsearch. For more information, see. This article introduces how to import and export elasticsearch. For more information, see. The Code is as follows: ORACLE_192.168.28.1 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.28.1) (PORT = 1521 )))(CONNECT_DATA =(SERVICE_NAME = oracle11)))ORACLE_192.168.

Common SET commands in ORACLE1 SET TIMING ON Description: displays the SQL statement running time. The default value is OFF. It is used in SQLPLUS and the time is accurate to 0.01 seconds. That is, 10 ms. In PL/SQL DEVELOPER, the time is accurate to 0.001 seconds:2 SET AUTOTRACE ON Description: allows you to analyze executed SQL statements. The default value is OFF. Set autotrace off: No AUTOTRACE report is generated. This is the default mode.Set auto

Label:Open the graphical window:1) Database Configuration Assistant windows (add DB Instance)$ dbca2) Oracle Net configuration Assistant windows (Configure listening)$ netca3) Open EM$ Oemapp Dbastudio (Open Enterprise Manager graphical interface)$ Opemapp Console (opens the Enterprise Manager graphical interface (same as the above command effect)) Common commands:$ lsnrctl start|stop|status (Start | stop

1. Connection commandsConnection: Conn [ect] user name/password @ network server [as sysdba/sysoper] If you log on to SYS, because sys can have two roles, You need to log on in the "Connect user name/password as role" format and specify the login role. Disconnect from the solution:Disc [onnect] Change User Password:Passw [ord] User NamePassword Jack ;)If you change your password, enter the "password" command. View the current Login User:Show user Exit the command window:Exit or quit Ii. File Ope

1. unlock a user. If the user is not unlocked when the database is installed, the user can be unlocked in sqlplus, for example: First use sys to log on, and then use alter user account unlock; 2. desc table nameTip: varchar2 () supports international languages; 3. select 10*10 from dual; select sysdate from dual; dual is an empty table for calculation.Double quotation marks are used to save the format. Oracle automatically converts lowercase letters

After oracle is installed, three users are generated by default, which are: SysUser: Super Administrator with the highest permissions. Its role isDBAThe password is:Change_on_install SystemUser: it is a system administrator and has high permissions. Its role isDbaoperThe password isManager ScottUser: common user, password isTiger 1. Create a user Create a new user in OracleCreate userCommand, and you must have the DBA (Database Administra

1. Database Export: three modes: Full Database Export, user export, and table export. 1. Command Line-full Database Export expuseridsystemsystem @ MyOraclefullyfile (c: tmp2004020601.dmp, c: tmp2004020602.dmp, c: tmp2004020603.dmp) filesize2GBlogc: tmp20040206.log Remarks: This command 1. Database Export: three modes: Full Database Export, user export, and table export. 1. command Line-full Database Export expuserid = system/system @ My Oracle full =

Common Oracle commandsToday, the database user is locked and checked, saying that the user will be locked if the logon error exceeds 10 times, therefore, with the unlock and password change operations, sqlplus/nolog is aborted without connecting to the database; the database is linked as dba: conn/as sysdba; the database crash mode and usage: startup: in open mode, the primary instance loads and opens the database. Normally, the Standby instance is in

I recently encountered oracle Database Import and Export when I was working on the project. Here I will record it to prevent myself from forgetting it. If anything is wrong or insufficient, you are welcome to make a brick. Haha ~Export command:1) single table Export: Exp username/password @ server alias tables = table name file = d: \ name. dmpCopy codeThe Code is as follows:Exp jm110/jm110 @ 120_2 tables = ajb file = d: \ ajb. dmpMultiple tables:Copy

After the 11g was installed, Em was never used. last night and this evening, we finally took time to start em. We also encountered a small problem, 1. Some em configuration commands Create an EM DatabaseEmca-repos createRebuilding an EM DatabaseEmca-repos recreate -------- this is very important. Generally, when it is not successfully created for the first time, you can use this command for subsequent creation.Delete An EM DatabaseEmca-repos dropCo