PL/SQL如何導入dmp文件,plsql導入dmp
-------------創建表空間
create tablespace portal_data datafile'E:\OracleDB\System_TableSpace\portal_data01.dbf' size 512M ;
create tablespace portal_idx datafile'E:\OracleDB\System_TableSpace\portal_idx01.dbf' size 256M ;
------------創建用戶並授權
create user portal identified by orcl default tablespace portal_data;
grant DBA to portal;
imp portal/orcl @localhost:1521/orcl
file=E:\OracleDB\Oracle_dmp\portalDB20160425.dmp
full=y log=E:\OracleDB\Oracle_dmp\csrsDB20160425.log ignore=y