Errors in import

From: Sidhu <amardeepsidhu_at_gmail.com>
Date: Mon, 17 Sep 2007 02:42:59 -0700
Message-ID: <1190022179.242459.160990@n39g2000hsh.googlegroups.com>

I have got a full database [Oracle 7] export file which I am importing to a 10g database. There are a total of about 12 schemas.

On 10g, I simply created a blank database and then all the tablespaces and ran the import. But it ran into a lot of errors with creation of db links, snapshots and finally creating comments on tables. Creation of db_links and snapshots failed with ORA-01031: insufficient privileges. And then there were comments on those snapshots which had to fail as snapshots didnt get created.

Then I created all the users in advance. Granted DBA role to all and set default role also "DBA". And again ran the import. Its still giving the errors. But otherwise,if I maually login with any of the user (out of those total 12), I can create dblinks and snapshots. Any ideas to avoid all these errors. If you need any other info please let me know.

Thanks
Sidhu Received on Mon Sep 17 2007 - 04:42:59 CDT