Database Utilities (MOSC)

MOSC Banner

imp-0007 error

edited Oct 4, 2012 12:37PM in Database Utilities (MOSC) 5 commentsAnswered
Creating a test to estimate the required time to import a 250 million row table using 10gR2 exp/imp utility vs. 10gR2 exp/imp datapump.

I've inherited a database where the old administrator created all logical backups using the old exp/imp utilities.    I want to transition them all to using the datapump.

For fun, I just wanted to see what improvement in time I could get importing a single 250 million row table.    I exported the table and am trying to import the table to a new schema so as not to disrupt current development work.   I've created the new test schema, but when I import I get the imp-0007 error that you must be a DBA to import into another user's schema.   But I did grant the DBA role to the current and new test schemas.   What privileges am I missing?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center