| imp error [message #127135] |
Fri, 08 July 2005 22:36  |
vadlamani
Messages: 39
Registered: November 2003
|
Member |
|
|
Does any one know why import is sipping the table
Export file created by EXPORT:V10.01.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > yes
Import entire export file (yes/no): no > yes
. importing SYSTEM's objects into SYSTEM
"CREATE TABLE "LOBTABLE" ("EMPLOYEE_ID" NUMBER, "RESUME" CLOB, "COMMENTS" CL"
"OB) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FR"
"EELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGIN"
"G NOCOMPRESS LOB ("RESUME") STORE AS "RESUME_SEG" (TABLESPACE "USERS" DISA"
"BLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 "
"FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("COMMENTS") STORE "
"AS "COMMENTS_SEG" (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 PCT"
"VERSION 10 CACHE STORAGE(INITIAL 1114112 FREELISTS 1 FREELIST GROUPS 1 BUF"
"FER_POOL DEFAULT))"
. . skipping table "LOBTABLE"
Import terminated successfully without warnings.
|
|
|
|
| Re: imp error [message #127244 is a reply to message #127135] |
Sun, 10 July 2005 15:17  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Because you are only listing the object in the dump file (List contents of import file only (yes/no): no > yes).
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
