1、剖析表 analyze table mzbs.db_code ESTIMATE STATISTICS SAMPLE 20 PERCENT;
, M e* W2 y/ H0 n0 A. @ 2、表空间打点和用户打点
' M S7 N+ S! Z --查看表空间和数据文件) k& d# j, K& l. W
select file_name,tablespace_name,autoextensible from dba_data_files;
$ o% f. W' _5 V" R* H7 g1 C) Y --数据表空间$ |9 ~- Y" F5 N0 x
CREATE TABLESPACE USER_DATA, V/ P1 a& `- c
LOGGING
9 g9 g/ s" |0 e- k+ |( f DATAFILE 'D:\ORACLE\ORADATA\ORCL\test.DBF' SIZE 50m REUSE ,
/ ]* h- D& U# @/ O6 t* W# l 'c:\USERS01112.DBF' SIZE 50m REUSE1 q* _; t, r8 M" d K1 s
AUTOEXTEND
; W( [8 v) w# z: m ON NEXT 1280K MAXSIZE 16383M EXTENT MANAGEMENT LOCAL/ \; K5 l" ]1 H" a
--改削表空间数据文件的路径
$ W1 f& a# C9 V* t! Z {" x. h ALTER TABLESPACE app_data8 i3 r: u* p# [3 i9 k( t1 x. `
RENAME
# W( e' g: C6 ~6 g% } DATAFILE '/DISK4/app_data_01.dbf'
]% g! ]' x5 j4 F1 i- t% A4 ~ TO '/DISK5/app_data_01.dbf';. z: z! w% B' R6 D# r
ALTER DATABASE* x2 {; P9 Q6 N# y
RENAME FILE '/DISK1/system_01.dbf'- R7 o, M2 ~/ h
TO '/DISK2/system_01.dbf';$ h/ J# [+ m2 @0 E$ p: [% x: _' H
--姑且表空间
# j) f3 F3 @) g: a u; }# R' ~ CREATE TEMPORARY1 z) R" j; E& r/ t: M0 v
TABLESPACE USER_DATA_TEMP TEMPFILE 'D:\TEMP0111.DBF'
. g* K0 N1 Z/ d- _0 N) W SIZE 50M REUSE AUTOEXTEND
* {3 ^% S3 c$ n/ O9 { ON NEXT 1024K MAXSIZE 16383M EXTENT MANAGEMENT LOCAL UNIFORM
; ^$ s5 u5 d# Y) O SIZE 1024K; P) N& ~& S2 h$ N: v
--增添数据文件
* o) l4 a7 b7 Y+ c3 E {, h+ K ALTER TABLESPACE USER_DATA6 v/ Q2 }* n" |, k2 L
ADD DATAFILE 'c:\USERS01113.DBF' SIZE 50M;
) T, x9 w) L6 ^! |: J; u& N A3 q) G ALTER TABLESPACE USER_DATA- g+ A# {5 s' Y9 I3 n, k
ADD DATAFILE 'c:\USERS01114.DBF' SIZE 50M* q6 ^# H% t& C% K) B2 A
AUTOEXTEND ON* \! E" v/ @4 I: S- B7 J0 w
;3 o, I8 ^0 j! f' A/ K7 ^
4 P( w" F; i2 t7 M& E+ V7 d- p
|