oracle10g数据导入导入导出

--删除用户
drop user ebank cascade;
--创建用户
CREATE USER ebank PROFILE "DEFAULT" IDENTIFIED BY ebank default tablespace ebank_db temporary tablespace ebank_db_temp;
--为用户授权
GRANT CONNECT,DBA,RESOURCE TO ebank;

--数据导入
impdp ebank/ebank directory=kyle dumpfile=ebank_2009120803.dmp schemas=ebank
--数据导出
expdp ebank/ebank DIRECTORY=kyle DUMPFILE=ebankebank20090301.dmp logfile=ebankebank20090301.log TABLESPACES=ebank_db;

--创建目录
CREATE DIRECTORY kyle as 'e:/';
--删除目录
drop directory kyle
--为目录授权
GRANT READ, WRITE ON DIRECTORY another TO ebank;
--查询目录
select * from dba_directories;