关于导入，导出

[superdreaming]

我在学习Oracle 导入，导出，开始成功导出了AAA数据库的所有对象。
但是，我故意删除了里面的表B,以为通过导入全部对象可以恢复该表B,
结果却报错.连数据库的方案都打不开.
给点支持朋友

[superdreaming]

连接到: 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"

成功终止导入，但出现警告。


-----结果没导成功

[melonboy]

你在导入的之前，要把要导入的方案里所有的表和视图都删了，然后整库导入（如果你是整库导出的话）就OK了！

[BlueskyWide]

导入前先把环境给搭好(表空间、回滚段、用户及权限)。

[Tom_Tan]

导入时指定IGNORE=Y

[black_snail]

what kind of err ?
please be more specific .