Home » RDBMS Server » Server Utilities » Error import
Error import [message #184757] Thu, 27 July 2006 15:18 Go to next message
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 Go to previous message
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 ??
Previous Topic: When clause SQL Loader
Next Topic: Re:Re: import problem with oracle 10.1.0 on Win2K
Goto Forum:
  


Current Time: Mon Dec 05 10:48:20 CST 2016

Total time taken to generate the page: 0.20849 seconds