是不是导出的结构如下所示的样子:DROP TABLE T_A001 CASCADE CONSTRAINTS ; CREATE TABLE T_A001 (
SHISAN_NO VARCHAR2 (15) NOT NULL,
SHISAN_EDA_NO VARCHAR2 (2) NOT NULL,
TORIHIKI_NO VARCHAR2 (15),
MEISAI_NO NUMBER (3),
KEIJOU_YMD VARCHAR2 (10),
TORIKESHI_KEIJOU_YMD VARCHAR2 (10),
KOUJI_NO VARCHAR2 (15),
SHISAN_GROUP_CD VARCHAR2 (10),
SHISAN_JOUTAI_SHURUI VARCHAR2 (2),
SHISAN_NAME VARCHAR2 (60),
KANJOUKAMOKU_CD VARCHAR2 (12),
KOZOUSAIMOKU_CD VARCHAR2 (12),
GENKASHOUKYAKU_RUIKEI_CD VARCHAR2 (12),
KANRI_BUSHO_CD VARCHAR2 (10),
KANRI_TANTOU_PS_NAME VARCHAR2 (20),
KANRI_TANTOU_PS_TEL_NO VARCHAR2 (15),
SAIMU_KANRI_BUSHO_CD VARCHAR2 (10),
DENPYOU_NO VARCHAR2 (10),
CHUMON_NO VARCHAR2 (10),
SHUTOKU_YMD VARCHAR2 (10),
SHIYOU_KAISHI_YMD VARCHAR2 (10),
SURYOU VARCHAR2 (15),
TANI VARCHAR2 (10),
TOUSHO_SHUTOKU_GAKU NUMBER (12),
SHOUHI_TAX_GAKU NUMBER (11),
SHOUHI_TAX_KBN VARCHAR2 (2),
INS_ID VARCHAR2 (10),
UPD_YMD VARCHAR2 (10),
UPD_TIME VARCHAR2 (8),
UPD_SHORI_ID VARCHAR2 (20),
UPD_ID VARCHAR2 (10),
SHUTOKU_KEIJOU_YMD VARCHAR2 (10),
CONSTRAINT I_T_A00100
PRIMARY KEY ( SHISAN_NO, SHISAN_EDA_NO )
USING INDEX
TABLESPACE AMILDB PCTFREE 10
STORAGE ( INITIAL 65536 ))
TABLESPACE AMILDB
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE; 可以用第三方工具TOAD,来实现.
在菜单"DATABASE"中/EXPORT/EXPORT TABLE SCRIPTS,所选择表的SCRIPT 可以全部导出来.
SHISAN_NO VARCHAR2 (15) NOT NULL,
SHISAN_EDA_NO VARCHAR2 (2) NOT NULL,
TORIHIKI_NO VARCHAR2 (15),
MEISAI_NO NUMBER (3),
KEIJOU_YMD VARCHAR2 (10),
TORIKESHI_KEIJOU_YMD VARCHAR2 (10),
KOUJI_NO VARCHAR2 (15),
SHISAN_GROUP_CD VARCHAR2 (10),
SHISAN_JOUTAI_SHURUI VARCHAR2 (2),
SHISAN_NAME VARCHAR2 (60),
KANJOUKAMOKU_CD VARCHAR2 (12),
KOZOUSAIMOKU_CD VARCHAR2 (12),
GENKASHOUKYAKU_RUIKEI_CD VARCHAR2 (12),
KANRI_BUSHO_CD VARCHAR2 (10),
KANRI_TANTOU_PS_NAME VARCHAR2 (20),
KANRI_TANTOU_PS_TEL_NO VARCHAR2 (15),
SAIMU_KANRI_BUSHO_CD VARCHAR2 (10),
DENPYOU_NO VARCHAR2 (10),
CHUMON_NO VARCHAR2 (10),
SHUTOKU_YMD VARCHAR2 (10),
SHIYOU_KAISHI_YMD VARCHAR2 (10),
SURYOU VARCHAR2 (15),
TANI VARCHAR2 (10),
TOUSHO_SHUTOKU_GAKU NUMBER (12),
SHOUHI_TAX_GAKU NUMBER (11),
SHOUHI_TAX_KBN VARCHAR2 (2),
INS_ID VARCHAR2 (10),
UPD_YMD VARCHAR2 (10),
UPD_TIME VARCHAR2 (8),
UPD_SHORI_ID VARCHAR2 (20),
UPD_ID VARCHAR2 (10),
SHUTOKU_KEIJOU_YMD VARCHAR2 (10),
CONSTRAINT I_T_A00100
PRIMARY KEY ( SHISAN_NO, SHISAN_EDA_NO )
USING INDEX
TABLESPACE AMILDB PCTFREE 10
STORAGE ( INITIAL 65536 ))
TABLESPACE AMILDB
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE; 可以用第三方工具TOAD,来实现.
在菜单"DATABASE"中/EXPORT/EXPORT TABLE SCRIPTS,所选择表的SCRIPT 可以全部导出来.
解决方案 »
- ado打开Oracle的程序的路径为什么不能包含右括号')'
- 再次求教触发器问题
- 求RMAN备份和恢复的脚本 oracle10g
- 如何配置Standby Database Standby Site 的 ini.ora文件
- 关于Oracle中,截取字符串的问题。
- 超级简单的代码 下面这个错在哪里?
- java.lang.ClassNotFoundException: oracle.jdbc.driver.oracledriver的问题
- 做水晶报表,以存储过程为数据来源,如果存储过程用到临时表,提示:对象不再存在!
- 关于oracle读取远程文件服务器中的csv文件的问题。。。
- 每个月表中都存在同一ID的记录,如何查询这月和上月的两条记录的某个字段的差,如钱的差!
- 急-----------使用BCB连接ORACLE的问题!
- imp 导入问题
在菜单"DATABASE"中/EXPORT/EXPORT TABLE SCRIPTS,所选择表的SCRIPT 可以全部导出来.
我try过了,真的不错。