Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Import to remote machine

901653Nov 22 2011 — edited Nov 23 2011
There are two servers:
Server A - with Oracle client (same version as database)
Server B - with database (11g)

I can transfer files just to Server A, and from there (server A) I can connect to database with given user1/pass1 (non-dba user).

Is it possible to import data to Server B from Server A without any additional privileges for user1?
I can generate dump file from 11g or 10g xe database and do any necessary modifications on this side.

This is what i have learn/tried, correct me if i am wrong:
This isn't possible with impdp or network link, old exp/imp could do this.
I have exported data from 10g xe with command:
exp user2/pass2 file=test.dmp log=test.log
Transfered .dmp file to server A, and then tried on Server A:
imp user1/pass1@conn1 file=test.dmp log=test.log

I got error: IMP-00013: only a DBA can import a file exported by another DBA
First time I exported data user2 had DBA role, second time I altered user and removed dba role. But the message remain the same. Do I have to set any additional parameters (fromuser - touser ?) ? What am I doing wrong?

Sorry, I am a bit of newbie and documentation confuses me.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 21 2011
Added on Nov 22 2011
#11g, #database-key-features, #export-import-sql-loader-external-tables, #import, #oracle
2 comments
229 views