oracle 11g远程导出数据库

zqxt =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 132.97.172.186)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ora11g)
    )
)

select distinct 'select dbms_metadata.get_ddl(''TABLESPACE'','''||tablespace_name||''') from dual;' from dba_tables;

select * from user_role_privs;

     select username,default_tablespace from user_users;

[sql] 
CREATE USER ityy_zqfw  
  IDENTIFIED BY zqfw123  DEFAULT TABLESPACE TBS_ITYY  
  TEMPORARY TABLESPACE TEMP  
  PROFILE DEFAULT  
  ACCOUNT UNLOCK;

[sql] 
GRANT CONNECT,CTXAPP, DBA ,RESOURCE TO ityy_zqfw;  
[sql] 
grant read,write on directory DATA_PUMP_DIR to ityy_zqfw;  
6、创建DB_LINK
create public database link zqxt connect to ityy_zqfw identified by zqfw123 using 'zqxt';