oracle创建表空间,用户和导入导出
+ ]; f/ V$ N+ N8 `5 A9 } * t3 A' g$ n: y- U# n" @
//创建临时表空间
- F' b, L" Z' ?. W& ?! f7 R2 g 2 P+ C9 @$ z1 f& x0 ~5 |
create temporary tablespace test_temp$ o& C0 P; R! y8 h W
8 [' ]8 G/ x$ [2 G
tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'1 ]% d, w* ?# m; p2 _. M- m) _: Z
' w% [& B3 B4 m" d8 i size 32m+ y* ?1 Y E- `) @$ J
# d# {$ G2 O& L) ]. n, T0 O: \% e
autoextend on
! W9 h( K; A( `$ H) \6 u ; H" y' T9 K: R
next 32m maxsize 2048m+ t1 o! s# T6 y1 f3 E8 j
6 i! B1 E1 Q3 ~% Y1 J' `/ n extent management local;
0 v0 R) L y: P5 X4 o0 w3 j: S3 K
( G" A' m! V5 } //创建数据表空间, h7 _6 `/ O: a! J, t: S
+ E" m9 }" S& k7 c
create tablespace test_data ?; `% R& m8 B# h
, P7 Z8 L1 }8 z- P! q logging' o3 K8 l! R# m e) O4 T+ y. {
4 X+ g9 S: C$ p+ F3 m$ W- J* `$ P
datafile 'E:\oracle\product\10.2.0\oradata\testserver\test_data01.dbf'" v6 \( r4 q7 Z, B' k: U% j( p
5 R6 }6 z+ f9 a size 32m
3 c4 {) ^& x( w: Z1 ]! m$ V # {0 _0 F( g/ W9 @' H! t% S% K
autoextend on
, A4 Z" b* D- d
$ S- p9 o+ n$ v+ H* t% y next 32m maxsize 2048m b- }, a& W& C
% U* s n9 k' j0 ^ extent management local;
; W# z- a; T" ? j) X
) _. C2 O3 Q9 |- T: q //创建用户并指定表空间
& h4 O5 u( D4 \7 i 2 r- A8 q/ e1 Q" z0 b( C% i
create user testserver_user identified by testserver_user7 n" g3 E7 M5 c3 J
: C6 ]- K/ {6 G% Z default tablespace test_data
7 E5 ?' t1 Z- \& W# [ i 6 h9 P; w. z' I" ?
temporary tablespace test_temp;
. S5 P( b' W" A: h( I5 m6 \
/ u( [! n. L2 W" c1 F: t# L //给用户授予权限( R# w. z* n E
8 M) ^8 D3 T4 p: Q grant connect,resource to testserver_user; (db2:指定所有权限) |