关于导入,导出 我在学习Oracle 导入,导出,开始成功导出了AAA数据库的所有对象。但是,我故意删除了里面的表B,以为通过导入全部对象可以恢复该表B,结果却报错.连数据库的方案都打不开.给点支持朋友 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 what kind of err ?please be more specific . 连接到: Oracle9i Enterprise Edition Release 9.0.1.1.1 - ProductionWith the Partitioning optionJServer Release 9.0.1.1.1 - Production经由常规路径导出由EXPORT:V09.00.01创建的文件已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入. 正在将SYSTEM的对象导入到 SYSTEM. 正在将WMG的对象导入到 WMG "ALTER SESSION SET CURRENT_SCHEMA= "WMG"" "CREATE TABLE "Categories" ("CATEGORYID" NUMBER(10, 0) NOT NULL ENABLE, "CAT" "EGORYNAME" VARCHAR2(15) NOT NULL ENABLE, "DESCRIPTION" CLOB, "PICTURE" BLOB" ") PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREE" "LISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" LOGGING LOB ("DESCRIPTION") S" "TORE AS (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 4096 PCTVERSION 10" " NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)) LOB ("PICTU" "RE") STORE AS (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 4096 PCTVERS" "ION 10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1))". . 正在跳过表 "Categories" "CREATE TABLE "Customers" ("CUSTOMERID" CHAR(5) NOT NULL ENABLE, "COMPANYNAM" "E" VARCHAR2(40) NOT NULL ENABLE, "CONTACTNAME" VARCHAR2(30), "CONTACTTITLE"" " VARCHAR2(30), "ADDRESS" VARCHAR2(60), "CITY" VARCHAR2(15), "REGION" VARCHA" "R2(15), "POSTALCODE" VARCHAR2(10), "COUNTRY" VARCHAR2(15), "PHONE" VARCHAR2" "(24), "FAX" VARCHAR2(24)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 ST" "ORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" LOGGI" "NG". . 正在跳过表 "Customers" "CREATE TABLE "EmployeeTerritories" ("EMPLOYEEID" NUMBER(10, 0) NOT NULL ENA" "BLE, "TERRITORYID" VARCHAR2(20) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INI" "TRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) T" "ABLESPACE "USERS" LOGGING". . 正在跳过表 "EmployeeTerritories" "CREATE TABLE "Employees" ("EMPLOYEEID" NUMBER(10, 0) NOT NULL ENABLE, "LAST" "NAME" VARCHAR2(20) NOT NULL ENABLE, "FIRSTNAME" VARCHAR2(10) NOT NULL ENABL" "E, "TITLE" VARCHAR2(30), "TITLEOFCOURTESY" VARCHAR2(25), "BIRTHDATE" DATE, " ""HIREDATE" DATE, "ADDRESS" VARCHAR2(60), "CITY" VARCHAR2(15), "REGION" VARC" "HAR2(15), "POSTALCODE" VARCHAR2(10), "COUNTRY" VARCHAR2(15), "HOMEPHONE" VA" "RCHAR2(24), "EXTENSION" VARCHAR2(4), "PHOTO" BLOB, "NOTES" CLOB, "REPORTSTO" "" NUMBER(10, 0), "PHOTOPATH" VARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS" " 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLES" "PACE "USERS" LOGGING LOB ("PHOTO") STORE AS (TABLESPACE "USERS" ENABLE STO" "RAGE IN ROW CHUNK 4096 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREELIS" "TS 1 FREELIST GROUPS 1)) LOB ("NOTES") STORE AS (TABLESPACE "USERS" ENABLE" " STORAGE IN ROW CHUNK 4096 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FRE" "ELISTS 1 FREELIST GROUPS 1))". . 正在跳过表 "Employees" "CREATE TABLE "Order Details" ("ORDERID" NUMBER(10, 0) NOT NULL ENABLE, "PRO" "DUCTID" NUMBER(10, 0) NOT NULL ENABLE, "UNITPRICE" NUMBER(19, 4) NOT NULL E" "NABLE, "QUANTITY" NUMBER(5, 0) NOT NULL ENABLE, "DISCOUNT" FLOAT(126) NOT N" "ULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL " "65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" LOGGING". . 正在跳过表 "Order Details" "CREATE TABLE "Orders" ("ORDERID" NUMBER(10, 0) NOT NULL ENABLE, "CUSTOMERID" "" CHAR(5), "EMPLOYEEID" NUMBER(10, 0), "ORDERDATE" DATE, "REQUIREDDATE" DAT" "E, "SHIPPEDDATE" DATE, "SHIPVIA" NUMBER(10, 0), "FREIGHT" NUMBER(19, 4), "S" "HIPNAME" VARCHAR2(40), "SHIPADDRESS" VARCHAR2(60), "SHIPCITY" VARCHAR2(15)," " "SHIPREGION" VARCHAR2(15), "SHIPPOSTALCODE" VARCHAR2(10), "SHIPCOUNTRY" VA" "RCHAR2(15)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL " "65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" LOGGING". . 正在跳过表 "Orders" "CREATE TABLE "Products" ("ProductID" VARCHAR2(10) NOT NULL ENABLE, "Product" "Name" VARCHAR2(10) NOT NULL ENABLE, "SupplierID" VARCHAR2(10), "CategoryID"" " VARCHAR2(10), "Quantity" VARCHAR2(10), "UnitPrice" VARCHAR2(10), "UnitsInS" "tock" VARCHAR2(10), "UnitsOnOrder" VARCHAR2(10), "ReorderLevel" VARCHAR2(10" "), "Discontinued" VARCHAR2(10) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INIT" "RANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TA" "BLESPACE "SPC_WMG" LOGGING". . 正在跳过表 "Products" "CREATE TABLE "Shippers" ("SHIPPERID" NUMBER(10, 0) NOT NULL ENABLE, "COMPAN" "YNAME" VARCHAR2(40) NOT NULL ENABLE, "PHONE" VARCHAR2(24)) PCTFREE 10 PCTU" "SED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST G" "ROUPS 1) TABLESPACE "USERS" LOGGING". . 正在跳过表 "Shippers" "CREATE TABLE "Suppliers" ("SUPPLIERID" NUMBER(10, 0) NOT NULL ENABLE, "COMP" "ANYNAME" VARCHAR2(40) NOT NULL ENABLE, "CONTACTNAME" VARCHAR2(30), "CONTACT" "TITLE" VARCHAR2(30), "ADDRESS" VARCHAR2(60), "CITY" VARCHAR2(15), "REGION" " "VARCHAR2(15), "POSTALCODE" VARCHAR2(10), "COUNTRY" VARCHAR2(15), "PHONE" VA" "RCHAR2(24), "FAX" VARCHAR2(24), "HOMEPAGE" CLOB) PCTFREE 10 PCTUSED 40 INI" "TRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) T" "ABLESPACE "USERS" LOGGING LOB ("HOMEPAGE") STORE AS (TABLESPACE "USERS" EN" "ABLE STORAGE IN ROW CHUNK 4096 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536" " FREELISTS 1 FREELIST GROUPS 1))". . 正在跳过表 "Suppliers" "CREATE TABLE "TOrders" ("ORDERID" NUMBER(10, 0) NOT NULL ENABLE, "CUSTOMERI" "D" CHAR(5), "EMPLOYEEID" NUMBER(10, 0), "ORDERDATE" DATE, "REQUIREDDATE" DA" "TE, "SHIPPEDDATE" DATE, "SHIPVIA" NUMBER(10, 0), "FREIGHT" NUMBER(19, 4), "" "SHIPNAME" VARCHAR2(40), "SHIPADDRESS" VARCHAR2(60), "SHIPCITY" VARCHAR2(15)" ", "SHIPREGION" VARCHAR2(15), "SHIPPOSTALCODE" VARCHAR2(10), "SHIPCOUNTRY" V" "ARCHAR2(15)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL" " 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SPC_WMG" LOGGING". . 正在跳过表 "TOrders" 成功终止导入,但出现警告。-----结果没导成功 如何清空审计的内容?是否关闭审计就可以? 多行记录变为一行记录的问题 请大侠帮忙看看这样的sql语句应该怎么写 插入数据提交过程中回滚段使用率为99.99% 如何能加快插入速度 Oracle 9i导入的问题 oracle8.17在win2000server安装过程中的问题,在线等! oracle managermenu server 方式登录的用户名和密码是什么 100分:关于存储过程和触发器的格式!!急!! 开始使用Oracle,大家多指教:) 在java中是不是不能调用Oracle的数据类型转换函数!!! 我创建的表在企业管理器重不能看见 各位数据库高手!!帮忙!!!
please be more specific .
连接到: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production经由常规路径导出由EXPORT:V09.00.01创建的文件
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
. 正在将SYSTEM的对象导入到 SYSTEM
. 正在将WMG的对象导入到 WMG
"ALTER SESSION SET CURRENT_SCHEMA= "WMG""
"CREATE TABLE "Categories" ("CATEGORYID" NUMBER(10, 0) NOT NULL ENABLE, "CAT"
"EGORYNAME" VARCHAR2(15) NOT NULL ENABLE, "DESCRIPTION" CLOB, "PICTURE" BLOB"
") PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREE"
"LISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" LOGGING LOB ("DESCRIPTION") S"
"TORE AS (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 4096 PCTVERSION 10"
" NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)) LOB ("PICTU"
"RE") STORE AS (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 4096 PCTVERS"
"ION 10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1))"
. . 正在跳过表 "Categories" "CREATE TABLE "Customers" ("CUSTOMERID" CHAR(5) NOT NULL ENABLE, "COMPANYNAM"
"E" VARCHAR2(40) NOT NULL ENABLE, "CONTACTNAME" VARCHAR2(30), "CONTACTTITLE""
" VARCHAR2(30), "ADDRESS" VARCHAR2(60), "CITY" VARCHAR2(15), "REGION" VARCHA"
"R2(15), "POSTALCODE" VARCHAR2(10), "COUNTRY" VARCHAR2(15), "PHONE" VARCHAR2"
"(24), "FAX" VARCHAR2(24)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 ST"
"ORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" LOGGI"
"NG"
. . 正在跳过表 "Customers" "CREATE TABLE "EmployeeTerritories" ("EMPLOYEEID" NUMBER(10, 0) NOT NULL ENA"
"BLE, "TERRITORYID" VARCHAR2(20) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INI"
"TRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) T"
"ABLESPACE "USERS" LOGGING"
. . 正在跳过表 "EmployeeTerritories" "CREATE TABLE "Employees" ("EMPLOYEEID" NUMBER(10, 0) NOT NULL ENABLE, "LAST"
"NAME" VARCHAR2(20) NOT NULL ENABLE, "FIRSTNAME" VARCHAR2(10) NOT NULL ENABL"
"E, "TITLE" VARCHAR2(30), "TITLEOFCOURTESY" VARCHAR2(25), "BIRTHDATE" DATE, "
""HIREDATE" DATE, "ADDRESS" VARCHAR2(60), "CITY" VARCHAR2(15), "REGION" VARC"
"HAR2(15), "POSTALCODE" VARCHAR2(10), "COUNTRY" VARCHAR2(15), "HOMEPHONE" VA"
"RCHAR2(24), "EXTENSION" VARCHAR2(4), "PHOTO" BLOB, "NOTES" CLOB, "REPORTSTO"
"" NUMBER(10, 0), "PHOTOPATH" VARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS"
" 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLES"
"PACE "USERS" LOGGING LOB ("PHOTO") STORE AS (TABLESPACE "USERS" ENABLE STO"
"RAGE IN ROW CHUNK 4096 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREELIS"
"TS 1 FREELIST GROUPS 1)) LOB ("NOTES") STORE AS (TABLESPACE "USERS" ENABLE"
" STORAGE IN ROW CHUNK 4096 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FRE"
"ELISTS 1 FREELIST GROUPS 1))"
. . 正在跳过表 "Employees" "CREATE TABLE "Order Details" ("ORDERID" NUMBER(10, 0) NOT NULL ENABLE, "PRO"
"DUCTID" NUMBER(10, 0) NOT NULL ENABLE, "UNITPRICE" NUMBER(19, 4) NOT NULL E"
"NABLE, "QUANTITY" NUMBER(5, 0) NOT NULL ENABLE, "DISCOUNT" FLOAT(126) NOT N"
"ULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL "
"65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" LOGGING"
. . 正在跳过表 "Order Details" "CREATE TABLE "Orders" ("ORDERID" NUMBER(10, 0) NOT NULL ENABLE, "CUSTOMERID"
"" CHAR(5), "EMPLOYEEID" NUMBER(10, 0), "ORDERDATE" DATE, "REQUIREDDATE" DAT"
"E, "SHIPPEDDATE" DATE, "SHIPVIA" NUMBER(10, 0), "FREIGHT" NUMBER(19, 4), "S"
"HIPNAME" VARCHAR2(40), "SHIPADDRESS" VARCHAR2(60), "SHIPCITY" VARCHAR2(15),"
" "SHIPREGION" VARCHAR2(15), "SHIPPOSTALCODE" VARCHAR2(10), "SHIPCOUNTRY" VA"
"RCHAR2(15)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL "
"65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" LOGGING"
. . 正在跳过表 "Orders" "CREATE TABLE "Products" ("ProductID" VARCHAR2(10) NOT NULL ENABLE, "Product"
"Name" VARCHAR2(10) NOT NULL ENABLE, "SupplierID" VARCHAR2(10), "CategoryID""
" VARCHAR2(10), "Quantity" VARCHAR2(10), "UnitPrice" VARCHAR2(10), "UnitsInS"
"tock" VARCHAR2(10), "UnitsOnOrder" VARCHAR2(10), "ReorderLevel" VARCHAR2(10"
"), "Discontinued" VARCHAR2(10) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INIT"
"RANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TA"
"BLESPACE "SPC_WMG" LOGGING"
. . 正在跳过表 "Products" "CREATE TABLE "Shippers" ("SHIPPERID" NUMBER(10, 0) NOT NULL ENABLE, "COMPAN"
"YNAME" VARCHAR2(40) NOT NULL ENABLE, "PHONE" VARCHAR2(24)) PCTFREE 10 PCTU"
"SED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST G"
"ROUPS 1) TABLESPACE "USERS" LOGGING"
. . 正在跳过表 "Shippers" "CREATE TABLE "Suppliers" ("SUPPLIERID" NUMBER(10, 0) NOT NULL ENABLE, "COMP"
"ANYNAME" VARCHAR2(40) NOT NULL ENABLE, "CONTACTNAME" VARCHAR2(30), "CONTACT"
"TITLE" VARCHAR2(30), "ADDRESS" VARCHAR2(60), "CITY" VARCHAR2(15), "REGION" "
"VARCHAR2(15), "POSTALCODE" VARCHAR2(10), "COUNTRY" VARCHAR2(15), "PHONE" VA"
"RCHAR2(24), "FAX" VARCHAR2(24), "HOMEPAGE" CLOB) PCTFREE 10 PCTUSED 40 INI"
"TRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) T"
"ABLESPACE "USERS" LOGGING LOB ("HOMEPAGE") STORE AS (TABLESPACE "USERS" EN"
"ABLE STORAGE IN ROW CHUNK 4096 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536"
" FREELISTS 1 FREELIST GROUPS 1))"
. . 正在跳过表 "Suppliers" "CREATE TABLE "TOrders" ("ORDERID" NUMBER(10, 0) NOT NULL ENABLE, "CUSTOMERI"
"D" CHAR(5), "EMPLOYEEID" NUMBER(10, 0), "ORDERDATE" DATE, "REQUIREDDATE" DA"
"TE, "SHIPPEDDATE" DATE, "SHIPVIA" NUMBER(10, 0), "FREIGHT" NUMBER(19, 4), ""
"SHIPNAME" VARCHAR2(40), "SHIPADDRESS" VARCHAR2(60), "SHIPCITY" VARCHAR2(15)"
", "SHIPREGION" VARCHAR2(15), "SHIPPOSTALCODE" VARCHAR2(10), "SHIPCOUNTRY" V"
"ARCHAR2(15)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL"
" 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SPC_WMG" LOGGING"
. . 正在跳过表 "TOrders" 成功终止导入,但出现警告。
-----结果没导成功