CREATE TEMPORARY TABLESPACE ZFMI_TEMP TEMPFILE 'D:\ORACLE\ORADATA\ZFMI\ZFMI_TEMP.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE ZFMI LOGGING DATAFILE 'D:\ORACLE\ORADATA\ZFMI\ZFMI.DBF' SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL;
DROP USER ZFMI CASCADE;
DROP TABLESPACE ZFMI INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
若資料檔已被手動刪除導致資料庫無法啟動:
SQL> STARTUP MOUNT SQL> ALTER DATABASE DATAFILE 'filename' OFFLINE DROP; SQL> ALTER DATABASE OPEN; SQL> DROP TABLESPACE tablespace_name INCLUDING CONTENTS;
CREATE USER ZFMI IDENTIFIED BY ZFMI DEFAULT TABLESPACE ZFMI TEMPORARY TABLESPACE ZFMI_TEMP;
GRANT DBA TO ZFMI;
| 參數 | 說明 | 典型值 |
|---|---|---|
| FULL=Y | 全庫導出/導入 | N |
| OWNER | 導出指定 Schema | - |
| TABLES | 導出指定表 | - |
| DIRECT=Y | 直接路徑導出(快) | N |
| CONSISTENT=Y | 一致性讀(需 UNDO 空間) | N |
| FILE | 轉儲檔名 | EXPDAT.DMP |
| LOG | 日誌檔 | - |
| IGNORE=Y | 導入忽略建立錯誤 | N |
| GRANTS/INDEXES/ROWS/CONSTRAINTS | 導入權限/索引/資料/約束 | Y |