| Error import [message #184757] |
Thu, 27 July 2006 15:18  |
faiz_hyd
Messages: 294
Registered: February 2006
|
Senior Member |
|
|
Hi,
Using DBA user account to export from schema A and import in Schema B , this error is coming, at first look i got this still import is taking time i don't whether it will give or all partition tables or for only this table it got ?
IMP-00008: unrecognized statement in the export file:
L 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "R1APP_DATA_Y05" LOGGING NOCOMPRESS, PARTITION "NOTE_TXT_PART_200510" VALUES LESS THAN (TO_DATE(' 2005-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 10 PCTUSED 40 INITRAN..
Just now saw after import all the 11 partitions table didn't got import.What am i missing while exporting whole schema which contains partition tables. it was simple exp command with all options
Any clue what could be the reason
Export using Orcle 9.2 release and import also same.
Thanks
[Updated on: Thu, 27 July 2006 16:02] Report message to a moderator |
|
|
|
| Re: Error import [message #186138 is a reply to message #184757] |
Sun, 06 August 2006 07:08  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
|
Use the correct parameters when runnning exp/imp and it should work. You might try ignore_errors=y ??
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
