oracle创建表空间,用户和导入导出3 e3 E2 ~6 {- u0 O" _- Q J
2 B6 d, i" G8 G1 M //创建临时表空间2 A0 T& f' t+ w7 s: v- [- r
. X9 Q, Q1 ~+ c1 Y6 B1 z3 z5 L2 I
create temporary tablespace test_temp) }7 w, i' O% i: e# g7 m9 E
) q! t$ a9 l7 T7 \5 b tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'! f* E# _; D6 a6 L2 g( c$ y$ k4 Q N. L
- c" A1 I; B4 X! |! c/ F
size 32m
/ r0 H4 |6 c4 T9 e! w
& e1 D3 Y# G3 Q9 l3 O, q# q/ }- j H autoextend on$ D1 M/ z+ L$ Y1 A* o
* o( I- U% z4 C% u next 32m maxsize 2048m
: B- l% U9 l* X, V# C
" t3 z3 {$ ]' p1 o; m extent management local;
5 X+ e% v# s- B . G# T- j0 D# v' q$ U# X+ U4 ?( I
//创建数据表空间
: j- J# ?5 \7 W% |+ A$ {
; k/ z: U6 a* G$ W2 s6 Z create tablespace test_data& L1 E* F+ K: Y, C6 j7 H
2 U7 ^/ E- O$ Z* e1 ]# u) L4 q
logging
' f: M3 }& f' H8 m" v
q4 E1 N* K) A1 i5 E3 l( A datafile 'E:\oracle\product\10.2.0\oradata\testserver\test_data01.dbf'
4 R: Y2 g: ?4 N" t/ h * l+ q' b/ e6 V* d# n# r3 F4 I
size 32m
/ t2 f* O, z, _+ s5 [
7 k* H6 t+ j3 s autoextend on( x3 e' T# y# `2 s+ Q$ p
) x' O$ ^, Y7 x3 D. {2 |/ h next 32m maxsize 2048m1 A$ i( u: o1 [9 V' W3 F9 J
9 P7 Y" c( J9 u3 ?: e extent management local;5 C' z& G$ c8 s
8 `. l" c; Z0 q; g |, A1 G* L
//创建用户并指定表空间
- E- O! O8 ^+ D1 A/ t# `7 z, e
7 j! \7 Y6 d' a8 ~: Z; i create user testserver_user identified by testserver_user' V" C( I/ w, E+ \) V
0 k& ]% D6 H8 I
default tablespace test_data! _! ~& {9 p" q' y6 e
/ S. [5 N, b, Q temporary tablespace test_temp;
& j& z* d# }) K) x2 Y 9 ?7 r1 N: _4 a1 i r- m8 E
//给用户授予权限7 J- m/ ]+ e( A
7 w: D6 j. \5 j, U9 z. o
grant connect,resource to testserver_user; (db2:指定所有权限) |