oracle导出表结构1.exp/imp工具在cmd中输入expusername/password@连接串回车，在进入如下时，输入no，就ok了导出表数据(yes/no)：yes>no；补充----------------exp/imp工具；带参数：rows=y——带数据导出导入；rows=n——不带数据的导出导入，只移植结构只导出3张表的结构：expHYPERLINK"mailto:user/pasword@dbServerName"user/pasword@dbServerNameowner=usertables=(tb1,tb2,tb3)rows=nfile=c:\1.dmp连带数据导出：expHYPERLINK"mailto:user/pasword@dbServerName"user/pasword@dbServerNameowner=usertables=(tb1,tb2,tb3)rows=yfile=c:\2.dmpimpHYPERLINK"mailto:user2/pasword@dbServerName2"user2/pasword@dbServerName2fromuser=usertouser=user2file=c:\1.dmp或者impHYPERLINK"mailto:user2/pasword@dbServerName2"user2/pasword@dbServerName2fromuser=usertouser=user2file=c:\2.dmp2.进入plsql找到table那个大项，点出来，下边会罗列出许多表右键点中你所需要的那个表名找到DBMS_Metadata然后选项里有ddl弹出来那个窗口就是你的表结构，拷贝出来直接在另一个库里执行就可以啦-----------------------------补充------------------------1）PLSQL里tools下exportuserobjectsof按shift批量选择表执行就行了；导出文件格式user_info.sql2）用PL/SQLDEVELOPER导出表结构：tools->exporttables>oralceexportexport是导出表结构或表数据和数据（是否选择Rows）user_info.dmptools->exporttables>SQLinserts页面，选中createtables选项，whereclause里写入whererownum<1只导出表结构user_info.sql3方法一：expuserid=scott/tigerowner=scottimpuserid=scott/tigerfull=yindexfile=scott.sql……morescott.sqlREMCREATETABLE"SCOTT"."BONUS"("ENAME"VARCHAR2(10),"JOB"REMVARCHAR2(9),"SAL"NUMBER,"COMM"NUMBER)PCTFREE10PCTUSED40REMINITRANS1MAXTRANS255STORAGE(INITIAL65536FREELISTS1FREELISTREMGROUPS1)TABLESPACE"USERS"LOGGINGNOCOMPRESS;REM...0rowsREMCREATETABLE"SCOTT"."DEPT"("DEPTNO"NUMBER(2,0),"DNAME"REMVARCHAR2(14),"LOC"VARCHAR2(13))PCTFREE10PCTUSED40INITRANS1REMMAXTRANS255STORAGE(INITIAL65536FREELISTS1FREELISTGROUPS1)REMTABLESPACE"USERS"LOGGINGNOCOMPRESS;REM...4rowsREMCREATETABLE"SCOTT"."DUMMY"("DUMMY"NUMBER)PCTFREE10PCTUSED40REMINITRANS1MAXTRANS255STORAGE(INITIAL65536FREELISTS1FREELISTREMGROUPS1)TABLESPACE"USERS"LOGGINGNOCOMPRESS;REM...1rowsREMCREATETABLE"SCOTT"."EMP"("EMPNO"NUMBER(4,0)NOTNULLENABLE,REM"ENAME"VARCHAR2(10),"JOB"VARCHAR2(9),"MGR"NUMBER(4,0),REM"HIRE