OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » IMP quest

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMP quest [message #231853]

Wed, 18 April 2007 10:58

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 ?

Report message to a moderator

Re: IMP quest [message #231855 is a reply to message #231853]

Wed, 18 April 2007 11:06

Mahesh Rajendran
Messages: 10707
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

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

Report message to a moderator

Re: IMP quest [message #232135 is a reply to message #231856]

Thu, 19 April 2007 10:42

Mahesh Rajendran
Messages: 10707
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?

Report message to a moderator

Previous Topic:	SQL Loader and dates
Next Topic:	IMP/EXP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 18 08:27:47 CDT 2024