【文件属性】:
文件名称:数据泵实战
文件大小:5KB
文件格式:TXT
更新时间:2016-12-09 04:51:36
expdp impdp
CREATE DIRECTORY DMPDIR AS 'E:\ETDATA\expdp';
CREATE DIRECTORY DMPDIR AS '/home/oracle/wxjexpdp';
CREATE DIRECTORY WXJ AS '/home/oracle/wxj';
CREATE DIRECTORY MYDIR AS '/home/oracle/wxj';
CREATE DIRECTORY impdpdir AS 'C:\impdpdir';
C:\impdpdir
CREATE DIRECTORY expdpdir AS 'C:\expdpdir';
C:\expdpdir
CREATE DIRECTORY expdpdir AS 'C:\expdpdir_orcl3';
CREATE DIRECTORY impdpdir AS 'C:\impdpdir_orcl3';
C:\expdpdir_orcl3
C:\impdpdir_orcl3
CREATE DIRECTORY expdpdir AS 'C:\expdpdir';
CREATE DIRECTORY impdpdirsde AS 'C:\impdpdir';
查询dba_directories查看所有directory:
select * from dba_directories;