Scroll Down

expdp new_fgw_gdzcgl/ directory=DATA_PUMP_DIR dumpfile=fgwscsercl20180104.dmp logfile=fgwscserc20180104.log reuse_dumpfiles=y;

impdp fgw_gdzcgl/fgw_gdzcgl@ DIRECTORY=DATA_PUMP_DIR DUMPFILE=fgwscsercl20171018.DMP REMAP_SCHEMA=导出用户:导入用户 remap_tablespace=导出空间名:导入空间名

exp keyersoft/keyersoft@ file=d:\zc-platform.dmp owner=keyersoft direct=y

imp keyersoft/keyersoft@ fromuser=keyerosft touser=keyersoft file=d:\zc-platform.dmp log=d:\zc-platform.log ignore=y

imp username/password@ file=bible_db full=y ignore=y

create bigfile tablespace HN_OUTER datafile
size 256m autoextend on;

alter database datafile '\oracle\oradata\anita_2008.dbf' autoextend on next 100m maxsize 10000m
create tablespace SCSERC_TEMP datafile 'E:\BSI\BI\ORACLE\SCSERC_HNDJB_TEMP_BI_DATA.DBF' size 20m
create user 用户名 identified by 密码
alter user 用户名 default tablespace 空间名
grant connect,resource to hn_outer;
grant dba to hn_outer;

select tablespace_name,
round(bytes / (1024 * 1024), 0) total_space
from dba_data_files
order by tablespace_name;

select username,default_tablespace from dba_users;

select * from dba_directories;

在cmd里set ORACLE_SID=sid

grant read,write on directory DATA_PUMP_DIR TO 用户名

select * from dba_data_files;
drop user 用户名称 cascade;
drop tablespace 表空间名称 including contents and datafiles cascade constraint;

select * from dba_directories where directory_name='DATA_PUMP_DIR';

执行以下SQLSelect 'alter table '||table_name||' allocate extent;' from user_tables where segment_created='NO';