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;
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;

浙公网安备 33010602011771号