Oracle tablespace management.

1.create tablespace
CREATE TABLESPACE USER_DATA
    LOGGING
    DATAFILE 'D:\oracle\product\10.2.0\oradata\victor\rsoa.dbf' SIZE 50m REUSE
           
    AUTOEXTEND
    ON NEXT  1280K MAXSIZE  16383M EXTENT MANAGEMENT LOCAL
2.drop tablespace
DROP TABLESPACE USER_DATA INCLUDING CONTENTS;
posted @ 2005-11-11 15:26  23热爱,自学业余码农。  阅读(192)  评论(0)    收藏  举报