TableSpace:
============
C:\
or acl
e\pr
oduct
\10.
2.0\
oradata\
orcl(
syst
em)
C:\
or acl
e\pr
oduct
\10.
2.0\
db_1\database
-permanent:
CREATETABLESPACEper mianent
abl
espaceDATAFI
LE
'per
dataf
il
e'SI
ZE10M REUSEAUTOEXTENDONNEXT19M MAXSI
ZE10M
LOGGI NG
DEFAULTCOMPRESS
PERMANENT
EXTENTMANAGEMENTLOCALAUTOALLOCATE
BLOCKSI ZE8K
SEGMENTSPACEMANAGEMENTAUTO
FLASHBACKON;
-
temporary:
CREATETEMPORARYTABLESPACEt emptablespaceTEMPFI
LE
'
temofi
l
e'SIZE10M REUSEAUTOEXTENDONNEXT10M MAXSI ZE10M
TABLESPACEGROUP' '
EXTENTMANAGEMENTLOCALUNI FORM SIZE1M;
-undo:
CREATEUNDOTABLESPACEundot ablespaceDATAFI
LE
'undof
il
e'SI
ZE10M REUSEAUTOEXTENDONNEXT10M MAXSI
ZE10M
RETENTI ONNOGUARANTEE
BLOCKSI ZE8K
FLASHBACKON;
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
*
Clust
er:
=========
[Link]
(
DEPT_I
D NUMBER(
10)
)
TABLESPACEPERMIANENTABLESPACE
I
NDEX
ROWDEPENDENCIES
CACHE
NOPARALLEL;
-Cl
ust
erSt
atement(
twot
abl
e):
[Link]
(
DEPT_I
D NUMBER(
10)
)
TABLESPACEPERMIANENTABLESPACE
I
NDEX
ROWDEPENDENCIES
CACHE
NOPARALLEL;
CREATETABLESYS.
EMP
(
EI
D NUMBER(
10),
DEPT_
ID NUMBER(10)
)
CLUSTERSYS.
CLUST(
DEPT_I
D)
NOCOMPRESS;
CREATETABLESYS.
DEPT
(
DEPT_
ID NUMBER(10)
,
NAME VARCHAR2(
50BYTE)
)
CLUSTERSYS.
CLUST(
DEPT_I
D)
NOCOMPRESS;
--
---
--
---
---
--
--
--
--
---
--
--
--
---
--
---
--
---
--
--
--
--
--
-*
Table:
========
1-standard:
CREATETABLESYS. empl oyee
(
id NUMBER( 10),
name VARCHAR2( 50) ,
age NUMBER( 10),
dept NUMBER( 10)
)
TABLESPACEPERMI ANENTABLESPACE
STORAGE (
BUFFER_ POOL DEFAULT
)
LOGGI NG
CACHE
NOPARALLEL
ROWDEPENDENCI ES
MONI TORING
ENABLEROW MOVEMENT;
ALTERTABLESYS.
empl
oyeeADD(
PRIMARYKEY
(
id))
;
2-i
ndex-
organi
zed:
CREATETABLESYS. empl
oyee
(
i
d NUMBER(10),
name VARCHAR2( 50)
,
age NUMBER( 10)
,
dept NUMBER(10),
CONSTRAINTemp_ i
d
PRIMARYKEY
(i
d)
)
ORGANIZATI
ONI NDEX
LOGGING
TABLESPACEPERMI ANENTABLESPACE
STORAGE (
BUFFER_POOL DEFAULT
)
NOPARALLEL
ROWDEPENDENCI ES
MONITORING;
3-
adv
ancedqueui
ng:
4-
global
tempor
ary
:
CREATEGLOBALTEMPORARYTABLESYS.
empl
oyee
(
i
d NUMBER(10),
name VARCHAR2(50)
,
age NUMBER( 10)
,
dept NUMBER(
10)
)
ONCOMMI TDELETEROWS
CACHE
ROWDEPENDENCIES;
ALTERTABLESYS.
empl
oyeeADD(
CONSTRAI
NTemp_i
d
PRIMARYKEY
(i
d))
;
--
--
--
--
--
--
--
--
--
--
--
--
--
--
---
--
--
--
--
---
--
--
--
--
--
--
*
I
ndex:
========
ALTERTABLESTANDTABLEADD(
PRIMARYKEY
(I
D,NAME, AGE,PLACEDATE, BI
RTHDAY, GID,QI
D,STATE,
GENDER)
USI
NGI NDEX
TABLESPACEPERMI ANENTABLESPACE
PCTFREE 10
I
NITRANS 2
MAXTRANS 255
STORAGE (
I
NITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELISTGROUPS 1
)
);
CREATEINDEXSYS.
indONSYS.
STANDTABLE
(NAME)
LOGGING
TABLESPACEPERMI ANENTABLESPACE
STORAGE (
BUFFER_POOL DEFAULT
)
NOPARALLEL
REVERSE
COMPRESS0;
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
*
Parti
ti
on:
============
1-ByRange:
CREATETABLESYS. sal
e
(
i
d NUMBER(10),
area VARCHAR2(15),
date DATE
)
LOGGING
PARTITIONBYRANGE( id)
(
PARTITI
ONFIRSTVALUESLESSTHAN( 200)
LOGGING
TABLESPACEPERMI ANENTABLESPACE
STORAGE (
BUFFER_POOL DEFAULT
)
,
PARTITI
ONSECONDVALUESLESSTHAN( 400)
LOGGING
TABLESPACEDATA
STORAGE (
BUFFER_POOL DEFAULT
)
,
PARTITI
ONLASTVALUESLESSTHAN( 600)
LOGGING
TABLESPACEINFO
STORAGE (
BUFFER_POOL DEFAULT
)
,
PARTITI
ONENDVALUESLESSTHAN( MAXVALUE)
LOGGING
TABLESPACEKNOW
STORAGE (
BUFFER_POOL DEFAULT
)
)
NOCACHE
NOPARALLEL
2-ByLi
st:
CREATETABLESYS. sal
e
(
i
d NUMBER(10),
area VARCHAR2(15),
date DATE
)
LOGGI NG
PARTITIONBYLI ST(area)
(
PARTITIONFIRSTVALUES( east)
LOGGING
TABLESPACEPERMI ANENTABLESPACE
STORAGE (
BUFFER_POOL DEFAULT
)
,
PARTITIONSECONDVALUES( sourth)
LOGGING
TABLESPACEKNOW
STORAGE (
BUFFER_POOL DEFAULT
)
,
PARTITIONTHI RDVALUES( west)
LOGGING
TABLESPACEDATA
STORAGE (
BUFFER_POOL DEFAULT
)
,
PARTITIONFOURTHVALUES( north)
LOGGING
TABLESPACEI NFO
STORAGE (
BUFFER_POOL DEFAULT
)
,
PARTITIONANOTHERVALUES( DEFAULT)
LOGGING
TABLESPACEDECK
STORAGE (
BUFFER_POOL DEFAULT
)
)
NOCACHE
NOPARALLEL
MONI TORING;
--
--
--
---
--
--
--
--
--
--
--
--
--
---
--
--
--
--
--
--
--
--
--
--
--
--
*
Transacti
on:
==============
-Commi t. -Roll
back. -
CommitComment. -
CommitFor
ce.
-Commi tImmeditel
y(wait
-Nowait
). -
Commi tWor
k. -Sav
ePoi
nt.
-Roll
backto..
.
-Sel
ect..
..
.forupdate.
-Settr
ansacti
onname' '.
-Settr
ansacti
onreadonl y
.
-
Sett
ransact
ioni
sol
ati
onl
evel
readCommi t
ted/UNCOMMI
TTED.
-
Sett
ransact
ioni
sol
ati
onl
evel
seri
ali
zabl
e.
-
Lock.
ALTERUSER"
HR"ACCOUNTLOCK;
-
Unlock.
ALTERUSER"
HR"ACCOUNTUNLOCK;
-
GRANT"RESOURCE"TO"HR";
-
REVOKE"RESOURCE"FROM "
HR";
-
Lockt
abl
e..inexcl
usi
verowmode;
-
Lockt
abl
e..inshar
erowmode;
-
Lockt
abl
e..inexcl
usi
vemode;
-
Lockt
abl
e..inshar
emode;
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
*
Plan:
======
@?\rdbms\admin\cat
plan.
sql
-
Explai
nplanfor..
..
-
Select*f
rom tabl
e(dbms_xpl
an.
displ
ay)
--
--
--
--
--
---
--
--
--
--
--
--
--
--
--
--
---
---
--
--
--
--
--
---
--
--
--
*
Backup:
========
-Rman- >connecttotargetsys/sysadmi
n
Backupdatabase
-r
un<
al
locatechannelcdev i
cestype..
.
.
.
>
-Exp->
Exp
Hr/hr
4096
C:\
expda.
dmp
UorT
-
rest
ore
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
*
User:
=======
-CREATEUSER"
RUQIA"IDENTIFI
EDBY"
123456789"
PROFI
LEMONITORI
NG_ PROFI
LE;
-
GRANT"DBA"TO" RUQI
A"WITHADMINOPTION;
-
GRANT"DELETE_CATALOG_
ROLE"TO" RUQI
A";
-
REVOKE"RESOURCE"FROM "RUQI
A";
-
ALTERUSER"
RUQI
A"DEFAULTROLE"
DBA"
;
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
*
Profi
l
e:
=========
CREATEPROFI LEMy Pr
ofil
eLIMIT
1-Resourcepar
ameter:
SESSIONS_PER_USERUNLIMITED
CPU_PER_SESSION2
CPU_PER_CALLDEFAULT
CONNECT_ TI
MEDEFAULT
IDLE_TI
MEDEFAULT
LOGICAL_READS_PER_SESSI
ONDEFAULT
LOGICAL_READS_PER_CALLDEFAULT
COMPOSI TE_LI
MITDEFAULT
PRIVATE_SGADEFAULT
2-Passwor
dparamet er
:
FAI
LED_LOGI
N_ ATTEMPTS3
PASSWORD_LIFE_TIME360
PASSWORD_REUSE_ TIMEDEFAULT
PASSWORD_REUSE_ MAXDEFAULT
PASSWORD_LOCK_ TIME10
PASSWORD_GRACE_ TIMEDEFAULT
PASSWORD_VERIFY_ FUNCTI
ONDEFAULT;
-
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
-*