本文共 1300 字,大约阅读时间需要 4 分钟。
实习期遇到的 导入导出的一些问题,在此做一个总结
SQL> create user RES_CUSH_TEST_LESS identified by RES_CUSH_TEST_LESS;
SQL> grant connect,resource to RES_CUSH_TEST_LESS;
SQL> grant create table,create database link to RES_CUSH_TEST_LESS;
或者直接给DBA角色 SQL> grant dba to RES_CUSH_TEST_LESS;SQL> create directory dbdata AS '/oradata1/dumpfile';
SQL> grant read,write on directory dbdata to RES_CUSH_TEST_LESS;
SQL> create public database link linkcush
connect to system identified by system using '(description = (address_list = (address = (protocol = tcp)(host = 10.45.59.190)(port = 1521))) (connect_data = (service_name = orcl)))'注意: 这里使用的用户名密码是远程数据库中的用户名和密码,导出使用的是这个用户,它必须有导出的权限, 如果没有须在数据库A中授权; 在数据库A中为用户daochuA授导出权限 SQL> grant exp_full_database to daochuA;nohup expdp RES_CUSH_TEST_LESS/RES_CUSH_TEST_LESS network_link=linkcush schemas=RES_CUSH_TEST directory=dbdata dumpfile=exp%u.dmp;
nohup impdp RES_CUSH_TEST_LESS/RES_CUSH_TEST_LESS directory=dbdata dumpfile=exp01.dmp remap_schema=RES_CUSH_TEST:RES_CUSH_TEST_LESS logfile=1229.log remap_tablespace=TBS_GENERAL:GENERAL2;
查看表空间大小 select a.TABLESPACE_NAME,sum(nvl(a.bytes,0)) from dba_free_space a group by a.TABLESPACE_NAME转载地址:http://ldtrn.baihongyu.com/