ORACLE导入导出、常用语句

exp abc/abc@ORCL file=D:\db_bak/orcl_bak_%date:~11,3%.dmp log=D:\db_bak/orcl_bak_%date:~11,3%.log owner=(aaa,bbb,ccc);

 

 

导入之前要确定有abc用户存在，并且是DBA权限.

imp abc/abc@ORCl file=d:\a.dmp fromuser=(aaa,bbb,ccc);

imp abc/abc@TEST file=\\172.16.1.110\e$\db_bak\orcl_bak_星期日.dmp fromuser=(aaa,bbb,ccc)

-----------------------------

select  count(table_name) from user_all_tables;  --表数量

select table_name,num_rows from (select * from user_tables) order by num_rows desc; --表数据

select count(1)  from biz_dispose_list where begin_date < to_date('2007-01-01','yyyy-MM-dd');

select tablespace_name,sum(bytes)/1024/1024/1024 from dba_data_files group by tablespace_name; --表空间大小

select * from v$logfile;--日志文件路径