PLSQL导出数据DML语句 exp导出DDL语句

  • 1 PLSQL导出DML语句

Tools -->export tables

 

  • 2 导入
C:\Users\Administrator>sqlplus
SQL> conn xxx/xx@URL:1521/XE
SQL> spool 'F:\AIT\LOG\05-13\DATA\IDHR_PROD_05_13_Data_01.log'
SQL> @F:\DATA.sql
SQL> spool off

 

  • 3 XP导出 create table / create function/ create procedure 语句
#exp IDHR/IDHR_0525@localhost:1521/xe  rows=n file=C:\Users\Administrator.cici-THINK\Desktop\test.sql

 

 

posted @ 2013-05-13 20:17  王超_cc  阅读(902)  评论(0)  编辑  收藏  举报