查询表、视图、存储过程、触发器的语据，用在数据库导入查看是否正确

select count(*) from user_tables;

select count(*) from user_objects where object_type='PROCEDURE';

select count(*) from user_views;

SELECT count(*)

FROM USER_SOURCE

WHERE TYPE='TRIGGER'

 

 

-------导入语据

imp qdaomujuku/rfx@orcl fromuser=rfxmujuku touser=qdaomujuku file=D:\\qingdao.dmp

 

----导出语据

exp rfxmujuku/rfx@orcl file=D:\\qingdao.dmp full=y