OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Imp issue (Linux)

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

Imp issue [message #352816]

Thu, 09 October 2008 14:29

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Hi

I have an issue, I haven’t been able to find much on this via Google and Metalink…
I am starting from step 1 and doing the migration procedure from start to finish I keep getting this error when I try to import a table even when all its indexes are set UNUSABLE:

. . importing table "ACCESSION_LINK"

IMP-00058: ORACLE error 1502 encountered

ORA-01502: index 'VGSM.ACCESSION_LINK_KIT_ODR_IDEN_IX' or partition of such index is in unusable state

Here is the background:

1) Move the Schema with no data

Export from source:

exp vgsm file=VGSM_USER.DMP log=VGSM_USER-EXPORT.LOG rows=n

Import into target (VGSM user has no objects yet):

imp vgsm file=VGSM_USER.DMP log=VGSM_USER-IMPORT.LOG

So now we have a schema with objects but no data.

2) Prepare the schema to import by running a script (DisableIndexTriggerFK.sql attached) that:

Mark all VGSM indexes UNUSABLE
Set all VGSM triggers DISABLE
Set all reference constraints DISABLE

3) Export a table from 8i source:

exp vgsm/@qllat2 FILE=ACCESSION_LINK.DMP LOG=ACCESSION_LINK-EXPORT.LOG

TABLES=ACCESSION_LINK INDEXES=N TRIGGERS=N GRANTS=N CONSTRAINTS=N FEEDBACK=1000

BUFFER=50000000

4) Import a table into 10g target:

imp vgsm/quintiles@ql10tst1 file=ACCESSION_LINK.DMP LOG=ACCESSION_LINK-IMPORT.LO

G IGNORE=Y FEEDBACK=10000 BUFFER=50000000 INDEXES=N SKIP_UNUSABLE_INDEXES=Y

. . importing table "ACCESSION_LINK"

IMP-00058: ORACLE error 1502 encountered

ORA-01502: index 'VGSM.ACCESSION_LINK_KIT_ODR_IDEN_IX' or partition of such index is in unusable state

Any ideas?

Report message to a moderator

Re: Imp issue [message #352822 is a reply to message #352816]

Thu, 09 October 2008 15:01

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Insufficient information.
No oracle version, No exact OS versions mentioned.
What exactly are you trying to?
>>I am starting from step 1 and doing the migration procedure from start to finish
Which first step are you talking about.

You are leaving us totally blue.
>>SKIP_UNUSABLE_INDEXES=Y
In certain 8.x versions, this will not work as expected. It is a documentation error.

Report message to a moderator

Re: Imp issue [message #352823 is a reply to message #352816]

Thu, 09 October 2008 15:01

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

And use CODE tags.

Report message to a moderator

Re: Imp issue [message #352824 is a reply to message #352816]

Thu, 09 October 2008 15:24

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Hi

Its a exp from Aix 8i and importing to 10.2.0.4 in Sun solaris 10.

sorry if i missed anything.

Puneet

Report message to a moderator

Previous Topic:	Importing data to table
Next Topic:	SQL*Loader logging off?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 01:07:24 CDT 2024