Oracle _ Study Notes: oracle4.09.05, oracle_2014.09.05

Oracle _ Study Notes: oracle4.09.05, oracle_2014.09.05
Oracle Study Notes

Test Database Configuration Information Global Database Name: xiuhao system identifier (SID): xiuhao server parameter file name: c: \ oracle \ dbs \ spfilexiuhao. oradatabase control URL: http: // C-1: 5500/emsys and system unlock

Edit

Open the current command in text format/

/

Execute the current command

L [num]

Show cache zone commands

Get [file]

Add files in the file to the buffer

C/[str]/[str]

Modify the content in the current statement

Spo [ol] [file]

• Save the executed command and result to file.
• Use spo off to stop saving

Use cmd to log on to sqlplus

Add as sysdba after Password

Lock/unlock user

• alter user [username] account unlock;
• Sys permission required

Linked user

• conn [username]/[passwd]
• conn / as sysdba(Default sys user)
• If sys is used, add the as sysdba after the password is required.

Query block size

• select name,value from V$parameter where name='db_block_size';
• Sys is required

Query a table space

• Select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS

Query control file, pfile

• show parameter control_files
• show parameter pfile
  • select name from V$controlfile;

From java to oracle to mysql

Data Files

• select name from v$datafile;

Authorize scott to be a sysdba user and use scott to log on

• grant sysdba to scott;
• conn scott/tiger as sysdba

Download complete Oracle learning notes txt

Oracle learning notes txt complete novel attachment has been uploaded to Baidu online storage, click to download for free:
It should be full.


ORACLE_OCP10g Study Notes

Call me with qq