OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » 8i exp to 9i imp

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

8i exp to 9i imp [message #144549]

Thu, 27 October 2005 01:49

galaxy
Messages: 62
Registered: October 2005

Member

Hello,

I've got some problems with the migration via imp/exp from Oracle 8i to Oracle 9i.

I did a full=y export from my 8i database.
The export from 8i works without errors.
(So I think this file will be all right)

Then I tried to import it (full=y) into 9i. But this doesn't work.

I started the export with the right exporttool from 8i and the import with the import tool of 9i.
(This can't be the Problem)

I read in the Internet that I have to create the Tablespaces maually in 9i. So thats what I did.

But when I tried to import the data, the problem is, that the system(9i) doesn't make any "create user" statement and no "create role" statement. Therefor the import works with many errors, because the system wants to do the grant statements t the roles or users.

Why doesn't the 9i Database create any user or role of the 8i database?

Did I make a mistake or what is the problem.

You can show what the 9i database tries to import when you do the command imp ... show=y

In this "show"-file there are no create user or create role statements.

But i must do a Migration 1:1 from 8i to 9i

Can somebody help me?

Thanks

Report message to a moderator

Re: 8i exp to 9i imp [message #144730 is a reply to message #144549]

Thu, 27 October 2005 19:49

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you considered using the 10g upgrade script to turn the 8i database into a 10g database instead of 9i? This means you can bypass the import/export.

David

Report message to a moderator

Re: 8i exp to 9i imp [message #144802 is a reply to message #144549]

Fri, 28 October 2005 07:26

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

Senior Member
Account Moderator

>>Why doesn't the 9i Database create any user or role of the 8i database?
it will try to do.
But it is not recomended.
8i and 9i differ a LOT.
Precreate the users , tablespaces etc.
Becuase 9i used LMT by default and TEmporary tablespace is assigned to the database
Your 8i import might try to create a DMT and temporary tablespaces are assigned explicitly to the user

SO, atleast precreate the user , tablespaces, roles etc.
Do user-by-user import ( You have more control here).
If there are too many users, then you think about automating the process .

>>In this "show"-file there are no create user or create role statements.

It does

oracle@mutation#imp scott/tiger log=somefile.log full=y show=y
oracle@mutation#cat somefile.log | grep "CREATE USER "
 "CREATE USER "OUTLN" IDENTIFIED BY VALUES '4A3BA55E08595C81' TEMPORARY TABLE"
 "CREATE USER "DBSNMP" IDENTIFIED BY VALUES 'E066D214D5421CCC' TEMPORARY TABL"
 "CREATE USER "WMSYS" IDENTIFIED BY VALUES '7C9BA362F8314299' TEMPORARY TABLE"
 "CREATE USER "DBADMIN" IDENTIFIED BY VALUES '1177FD6FD635EB27' TEMPORARY TAB"
 "CREATE USER "TEST" IDENTIFIED BY VALUES 'B61BD63BC061823C' TEMPORARY TABLES"
 "CREATE USER "TEST2" IDENTIFIED BY VALUES 'B3D53232BA2B2059' TEMPORARY TABLE"
 "GRANT CREATE USER TO "SYSTEM""

>>I started the export with the right exporttool from 8i and the
>>import with the import tool of 9i.
>>(This can't be the Problem)

THis might be a problem.
You are supposed to export with the lower version exp and import using same lower version imp
or
Install the export/import views into other version.

>>But i must do a Migration 1:1 from 8i to 9i
I dont understand that.

Report message to a moderator

Re: 8i exp to 9i imp [message #144936 is a reply to message #144802]

Sat, 29 October 2005 03:50

suryaevl
Messages: 8
Registered: October 2005
Location: Chennai

Junior Member

If it is possible to do export via 9i ( by connecting the servers physically and thro dblinks ) then
the import cannot be a problem.

Tryout this.

Report message to a moderator

Re: 8i exp to 9i imp [message #144940 is a reply to message #144936]

Sat, 29 October 2005 04:28

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

Senior Member
Account Moderator

Suryaevl wrote:
>>export via 9i ( by connecting the servers physically and thro dblinks )

Could you please explain this.
How does export and database links work together?

[Updated on: Sat, 29 October 2005 04:28]

Report message to a moderator

Previous Topic:	export help
Next Topic:	Zipping a DMP File

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 13 11:32:45 CST 2025