Home » RDBMS Server » Server Utilities » Imp issue (Linux)
Imp issue [message #352816] Thu, 09 October 2008 14:29 Go to next message
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?
Re: Imp issue [message #352822 is a reply to message #352816] Thu, 09 October 2008 15:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Imp issue [message #352823 is a reply to message #352816] Thu, 09 October 2008 15:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And use CODE tags.
Re: Imp issue [message #352824 is a reply to message #352816] Thu, 09 October 2008 15:24 Go to previous message
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
Previous Topic: Importing data to table
Next Topic: SQL*Loader logging off?
Goto Forum:
  


Current Time: Sat Dec 10 04:58:02 CST 2016

Total time taken to generate the page: 0.07131 seconds