方案名为BOB中已存在表S,P,J,现在新建一个表SPJ,命令如下:
CREATE TABLE "BOB"."SPJ" (
"SNO" VARCHAR2(10) NOT NULL,
"PNO" VARCHAR2(10) NOT NULL,
"JNO" VARCHAR2(10) NOT NULL,
"QTY" VARCHAR2(10) NOT NULL,
PRIMARY KEY("SNO", "PNO", "JNO"),
FOREIGN KEY("SNO") REFERENCES "BOB"."S"("SNO"),
FOREIGN KEY("PNO") REFERENCES "BOB"."P"("PNO"),
FOREIGN KEY("JNO") REFERENCES "BOB"."J"("JNO")
)
TABLESPACE "BOB" ;
然后我用insert语句插入数据,然后用exp将表SPJ导出,但是导出提示导出0个数据,然后我重启之后数据就自动不见了,还请高手指点……
CREATE TABLE "BOB"."SPJ" (
"SNO" VARCHAR2(10) NOT NULL,
"PNO" VARCHAR2(10) NOT NULL,
"JNO" VARCHAR2(10) NOT NULL,
"QTY" VARCHAR2(10) NOT NULL,
PRIMARY KEY("SNO", "PNO", "JNO"),
FOREIGN KEY("SNO") REFERENCES "BOB"."S"("SNO"),
FOREIGN KEY("PNO") REFERENCES "BOB"."P"("PNO"),
FOREIGN KEY("JNO") REFERENCES "BOB"."J"("JNO")
)
TABLESPACE "BOB" ;
然后我用insert语句插入数据,然后用exp将表SPJ导出,但是导出提示导出0个数据,然后我重启之后数据就自动不见了,还请高手指点……
======================================
试试 rows=y
DDL(CREATE,ALTER,DROP)会自动COMMIT的不需要手动COMMT