Oracle导出输入的方法_AlienLee的博客

set echo on

spool D:\Development\Oracle\Thinkpad\log\CreateDBFiles.log

CREATE TABLESPACE "ALIEN" LOGGING DATAFILE 'D:\Development\Oracle\Thinkpad\oradata\orcl\alien01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE 'D:\Development\Oracle\Thinkpad\oradata\orcl\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP";

CREATE TABLESPACE "TOOLS" LOGGING DATAFILE 'D:\Development\Oracle\Thinkpad\oradata\orcl\tools01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT  320K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

CREATE TABLESPACE "USERS" LOGGING DATAFILE 'D:\Development\Oracle\Thinkpad\oradata\orcl\users01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

CREATE UNDO TABLESPACE "UNDOSTB1" DATAFILE 'D:\Development\Oracle\Thinkpad\oradata\orcl\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  5120K;

spool offset echo on

spool