Home » RDBMS Server » Server Utilities » IMP quest
IMP quest [message #231853] Wed, 18 April 2007 10:58 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
i did an import of table with option IGNORE=N .All rows are imported but i could see following warning.
=========================
Export file created by EXPORT:V08.01.07 via conventional path
import done in US7ASCII character set and US7ASCII NCHAR character set
. importing PRODUSER's objects into TEMPUSER
IMP-00015: following statement failed because the object already exists:
"CREATE UNIQUE INDEX "PBSYSCATPBT_IDX" ON "SYSTEM"."PBCATTBL" ("PBT_TNAM" , "
""PBT_OWNR" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 16384 NEXT"
" 16384 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUP"
"S 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING"
. . importing table "PROD_TABLE" 8494 rows imported
Import terminated successfully with warnings.
[1] + Done nohup ./import_table_PROD_TABLE.sh &
=================================
How SYSTEM.PBCATTBL and its unique index came in picture ?
Re: IMP quest [message #231855 is a reply to message #231853] Wed, 18 April 2007 11:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator

IGNORE=N shows the object creation erros and IGNORE=Y will not show them.
Seems the said INDEX is been created on a table owned by SYSTEM.

[Updated on: Wed, 18 April 2007 11:08]

Report message to a moderator

Re: IMP quest [message #231856 is a reply to message #231853] Wed, 18 April 2007 11:13 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
But i am importing only one user tbale(PROD_TABLE) .Dont understand why system table camein picture.here is my import script .
imp / file=PRODDB_20070417.223518_full.dmp log=import_table_PROD_TABLE.log ignore=N \
fromuser=PRODUSER touser=TEMPUSER tables=PROD_TABLE

Thanks
Re: IMP quest [message #232135 is a reply to message #231856] Thu, 19 April 2007 10:42 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Looks wierd.
I dont have 8i around to reproduce your case.
Is this a reproducible case? what happens with an explicity INDEXES=N with import?
Previous Topic: SQL Loader and dates
Next Topic: IMP/EXP
Goto Forum:
  


Current Time: Tue Dec 06 06:49:22 CST 2016

Total time taken to generate the page: 0.18518 seconds