select * from dba_sys_privs where  grantee='DBA';

select * from dba_roles;

select * from system_privilege_map order by name;

select distinct privilege from dba_tab_privs;

select tablespace_name from dba_tablespaces;

select * from dba_role_privs where grantee='用户名';

select * from dba_sys_privs where grantee='DBA';
  或者：
  select * from role_sys_privs where role='DBA';

select * from dba_tab_privs where grantee='角色名';

cd E:\oracle\product\10.2.0\db_1\BIN回车
 ------------------------------------------

exp userid=scott/tigger@orcl tables=(emp) file=e:\Oracle资料\LearnOracleByMyself\emp.dmp 回车

exp userid=scott/tigger@orcl tables=(emp) file=d:\emp3.dmp rows=n

exp userid=scott/tigger@orcl tables=(emp) file=d:\e3.dmp direct=y

exp userid=system/admin@orcl tables=(scott.emp) file=e:\Oracle资料\LearnOracleByMyself\emp.dmp 回车

exp userid=scott/tigger@orcl owner=scott file=e:\Oracle资料\LearnOracleByMyself\scott.dmp

exp userid=system/admin@orcl tables=(scott.emp) file=e:\Oracle资料\LearnOracleByMyself\scott2.dmp 回车

xp userid=system/admin@orcl full=y inctype=complete file=e:\Oracle资料\LearnOracleByMyself\orcl.dmp

imp userid=scott/tigger@orcl tables=(emp) file=e:\Oracle资料\LearnOracleByMyself\emp.dmp

imp userid=system/admin@orcl tables=(emp) file=e:\Oracle资料\LearnOracleByMyself\emp.dmp touser=scott

imp userid=scott/tigger@orcl tables=(emp) file=e:\Oracle资料\LearnOracleByMyself\emp.dmp rows=n

imp userid=scott/tigger@orcl tables=(emp) file=e:\Oracle资料\LearnOracleByMyself\emp.dmp ignore=y

imp userid=scott/tigger@orcl file=e:\Oracle资料\LearnOracleByMyself\emp.dmp

imp userid=system/admin@orcl file=e:\Oracle资料\LearnOracleByMyself\emp.dmp touser=scott

imp userid=system/admin@orcl full=y file=d:\xx.dmp