ORACLE__ Study Note 2014.09.05

Oracle Learning Note 2014.09.05

测试数据库配置的信息全局数据库名：xiuhao系统标识符(SID)：xiuhao服务器参数文件名：c:\oracle\dbs\spfilexiuhao.oradatabase control URL: http://C-1:5500/emsys以及system解锁

Edit

Open the current command in text Format/

/

Execute current command

l [Num]

Show Buffer command

get [file]

Adding files from file to buffer

C/[str]/[str]

Modify the contents of the current statement

Spo[ol] [file]

• Save executed commands and results to file
• Terminate save with Spo off

Login with cmd sqlplus

Add as SYSDBA after password

Lock \ Unlock User

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

Linked users

• conn [username]/[passwd]
• conn / as sysdba(Default SYS user)
• If you use SYS, you need a password to add as Sysdba

Query block Size

• select name,value from V$parameter where name=‘db_block_size‘;
• Need to use SYS

Querying table Spaces

• 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;

从java到oracle到mysql

Data files

• select name from v$datafile;

Authorized user Scott is a SYSDBA user and uses Scott to log in

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

ORACLE__ Study Note 2014.09.05