oracle导入、导出有两种方式:
A)imp、exp。
B)impdp、expdp。
【一】、查看oracle导出目录:(数据库默认的data pump dir)我这里是DATA_PUMP_DIR
select * from dba_directories;
【二】、用imp导出、导入dmp包
exp admin/123456@127.0.0.1:1521/orcl file=c:\admin180319.dmp owner=admin
imp usename/password@SID full=y file= c:\admin180319.dmp ignore=y
【三】、用三mpdp导出、导入dmp包
expdp admin/123456@127.0.0.1:1521/orcl schemas=admin dumpfile=admin0903.dmp directory=DATA_PUMP_DIR schemas=admin
impdp admin/123456@localhost/orcl directory=DATA_PUMP_DIR dumpfile=admin_20180903.DMP remap_schema=admin:admin transform=OID:N
【四】、查看oracle所有的表空间
select tablespace_name from sys.dba_tablespaces;
【五】、查询所有schema
select username from sys.dba_users; //一个用户(user)对应一个方案(schema)
【六】、查询schema下的所有表
select table_name from sys.dba_tables where owner='schema名';
【七】、查询所有的schema及所属的所有表
select s.username "schema",t.table_name "table_name" from sys.dba_users s left join sys.dba_tables t on s.username=t.owner order by s.username asc;