Home » RDBMS Server » Backup & Recovery » Import Issues
Import Issues [message #188934] Tue, 22 August 2006 08:38 Go to next message
srinivas4u2
Messages: 66
Registered: June 2005
Member
Hi,

I am exporting form 9.2.0.7 to 10.2.0.2.

I did a full export of 9.2.0.7 database and I am performing a fromuser touser import in 10.2.0.2.

Some tables have rowid column, now I get a the following displayed -

Note: table contains ROWID column, values may be obsolete

I understand this column is there for searching my rowid, now how do I get the values to not be obsolete?


Does anyone know what the following error could be corrected?

IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN TATUS := DBMS_JAVA.START_IMPORT('META-INF/MANIFEST.MF', 0, 30, "
"0, 3, 95, 0); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN TATUS := DBMS_JAVA.START_IMPORT('oracle/wh/runtime/xml/ElementH"
"andler', 0, 29, 0, 3, 1171, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored

I got this error many times.

Thanks,
Srinivas

Report message to a moderator

Re: Import Issues [message #188939 is a reply to message #188934] Tue, 22 August 2006 08:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Seems like you have not installed the JVM /JAVA options in your target 10g database.

>>Note: table contains ROWID column, values may be obsolete
As long as this column that was named ROWID does not contain the the rowid of records from database, you may just ignore it.

Report message to a moderator

Re: Import Issues [message #188947 is a reply to message #188939] Tue, 22 August 2006 09:07 Go to previous messageGo to next message
srinivas4u2
Messages: 66
Registered: June 2005
Member
Thanks very much for your response Mahesh!

I am however having data in the rowid column. How do I correct it now?

And how do I check if I have installed java/jvm options are not, right now I don't have the cd mounted on the server to check using the oui.

Thanks,

Report message to a moderator

Re: Import Issues [message #188950 is a reply to message #188947] Tue, 22 August 2006 09:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I am however having data in the rowid column. How do I correct it now?
I have no idea. What are you using it for.
ROWIDS are unique within the table. Not within the database.
SO when you export and import, the actual rowid of the records in table will change. if you the values stored in this column is supposed to correspond to such rowids, it is of nomore usage.

If you are not using the java options, just can just ignore.
Initjvm and rmjvm.sql are used to install and uninstall JVM options. As said, if you are not using JavaStoredProcedures, ignore the message.

Report message to a moderator

Re: Import Issues [message #188956 is a reply to message #188950] Tue, 22 August 2006 10:10 Go to previous messageGo to next message
srinivas4u2
Messages: 66
Registered: June 2005
Member
Thanks much Mahesh! Greatly appreaciate for your quick responses!

My initial question should have been, would the rowid column be populated as per the rowid it is assigned in the new database or the rowid values would be be imported into the new database just as other rows of the tables.

I understand these columns were added to search using rowid.

From what you have told, it's clear that the rowid would be populated as per the rowid assigned in the new database. And this is what I want.

At the moment we don't use java stored procedures, but whenever we intend to use I can install it in the existing Oracle bin right?

Thanks,
Srinivas

Report message to a moderator

Re: Import Issues [message #188963 is a reply to message #188956] Tue, 22 August 2006 10:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> would the rowid column be populated as per the rowid it is assigned in the new database
NO
>>the rowid values would be be imported into the new database just as other rows of the tables
Yes
>> but whenever we intend to use I can install it in the existing Oracle bin right
the scripts are available in $ORACLE_HOME/rdbms/admin.
Quoting a doc from metalink
Quote:


These messages can be ignored so long as the rowid values in these columns are not supposed to point to any valid rowid in this database. The Rowid values in the database from which export was taken might be pointing to some valid rowids. When import is done into another database, since table reorganization is done, the rowids are going to change in this database. Hence the old rowids might not point to a valid rowid. Import imports these column values correctly inspite of these warnings.


>>I understand these columns were added to search using rowid.
Just another bad idea.
ROWID may change. you cannot (always) use it for searching.

[Updated on: Tue, 22 August 2006 10:34]

Report message to a moderator

Re: Import Issues [message #189001 is a reply to message #188963] Tue, 22 August 2006 13:41 Go to previous messageGo to next message
srinivas4u2
Messages: 66
Registered: June 2005
Member
Thanks for the update. I came here to update the thread with the information but you had already updated it.

Thanks,
Srinivas

Report message to a moderator

Re: Import Issues [message #189017 is a reply to message #188934] Tue, 22 August 2006 15:26 Go to previous messageGo to next message
srinivas4u2
Messages: 66
Registered: June 2005
Member
Thanks Mahesh, but I did not find the sqls in rdbms/admin instead I found it under /javavm.

Incase I want to use java later, I can still ignore the errors that I got while importing right? Do you have any idea about what was looking for java/jvm?

Thanks,

Report message to a moderator

Re: Import Issues [message #189023 is a reply to message #188934] Tue, 22 August 2006 16:30 Go to previous message
srinivas4u2
Messages: 66
Registered: June 2005
Member
The errors were because source db had jvm while the target didn't have.

Thanks,

Report message to a moderator

Previous Topic: how to back up and restore the tables
Next Topic: RMAN Backup issue
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 15:34:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.