ORACLE导出和pl/sql导出

Question

这个是pl/sql导出的
prompt PL/SQL Developer import fileprompt Created on 2013年8月5日星期一 by Administrator
set feedback off
set define off
prompt Dropping TEST1...
drop table TEST1 cascade constraints;
prompt Creating TEST1...
create table TEST1
(
  ID   INTEGER not null,
  NAME VARCHAR2(20)
)
;
alter table TEST1
  add primary key (ID);prompt Disabling triggers for TEST1...
alter table TEST1 disable all triggers;
prompt Loading TEST1...
insert into TEST1 (ID, NAME)
values (4, 'hello');
insert into TEST1 (ID, NAME)
values (3, '2');
commit;
prompt 2 records loaded
prompt Enabling triggers for TEST1...
alter table TEST1 enable all triggers;
set feedback on
set define on
prompt Done.这个是用exp导出的TEXPORT:V10.02.01
DDKS
RTABLES
2048
0
20
0
TTg 
                                                 星期一 8月 5 9:50:23 2013d:\test1.sql                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    d    `
$
 
#G###A? ?Tg                                     d    `
$
 
#G###A? ?TT                                      +00:00   BYTE UNUSED
 2 INTERPRETED DISABLE:ALL  
METRICST
TABLE "TEST1"
CREATE TABLE "TEST1" ("ID" NUMBER(*,0), "NAME" VARCHAR2(20))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "DKS" LOGGING NOCOMPRESS
INSERT INTO "TEST1" ("ID", "NAME") VALUES (:1, :2)
   
  T
      ? hello   ?
 2  
ANALSTATS TS "TEST1"
N BEGIN  DBMS_STATS.SET_TABLE_STATS(NULL,'"TEST1"',NULL,NULL,NULL,2,5,7,6); END;
ANALSTATS TS "TEST1"
?{ DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C104'; SREC.MAXVAL := 'C105'; SREC.EAVS := 0; SREC.CHVALS := NULL; # SREC.NOVALS := DBMS_STATS.NUMARRAY( 3,4& ); SREC.BKVALS := DBMS_STATS.NUMARRAY( 0,1k ); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"TEST1"','"ID"', NULL ,NULL,NULL,2,.5,0,srec,3,6); END;  
ANALSTATS TS "TEST1"
? DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '32'; SREC.MAXVAL := '68656C6C6F'; SREC.EAVS := 0; SREC.CHVALS := NULL; # SREC.NOVALS := DBMS_STATS.NUMARRAY(I 259614842926741000000000000000000000,542055986857714000000000000000000000& ); SREC.BKVALS := DBMS_STATS.NUMARRAY( 0,1m ); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"TEST1"','"NAME"', NULL ,NULL,NULL,2,.5,0,srec,4,6); END;  
METRICST期表活动
METRICET 2
METRICSTPost-inst procedural actions 
METRICET 2
METRICSTDeferred analyze commands 
TABLE "TEST1"
ANALCOMPUTE TS "TEST1" ANALYZE  TABLE "TEST1"  ESTIMATE STATISTICS 
ENDTABLE
METRICET 3
METRICETG0
EXIT
EXIT
怎么是乱码 啊                                                                                                                                                                                                                                                                                                                                                            

Answer 1

exp导出的dmp文件，打开本来就是乱码的。。

Answer 2

我这个导出的.sql 怎么才能和pl/sql导出的一样 或者 起码 没有乱码

Answer 3

我用sql developer（oracle自带的工具，可以去oracle网站下载，170MB左右）导出过SQL语句，工具-->数据库导出
命令行怎么弄，我也在找。

Answer 4

不利于工具的话，导出sql脚本文件，好像达不到吧？

Answer 5

Oracle没有导出SQL脚本的功能。

Answer 6

但是我要做的是用java 导出sql怎么做

Answer 7

但是我要做的是用java 导出sql怎么做那你应该把问题说清楚 
问题都说不清楚 别人怎么回答你

Answer 8

但是我要做的是用java 导出sql怎么做http://www.docin.com/p-372263212.html