OraFAQ Forum: Server Utilities » Backup & Import Database

Home » RDBMS Server » Server Utilities » Backup & Import Database | Problems with user-rules

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

Backup & Import Database | Problems with user-rules [message #265050]

Wed, 05 September 2007 05:46

nic.
Messages: 6
Registered: September 2007

Junior Member

Hello together,

i have a "little" problem:

I want to create a backup from my Oracle DB. I use the following script with a DOS command:
exp userid=system/manager file=c:\full_exp.dmp log=c:\full_exp.log compress=no full=yes statistics=none consistent=yes

The main problem is the new DB. We want to import the backup but the problem is, that we use the system-user to create the backup. We want to import them on another user (fe. "XYZ").
On the old DB, the user "XYZ" is created and is a DBA.
When i want to start an export with the user "XYZ" i cant login with username / password.

Where is the problem? Do i have to change the properties / rules from user "XYZ"?

Thank for your help & with best regards

Nic.

Report message to a moderator

Re: Backup & Import Database | Problems with user-rules [message #265067 is a reply to message #265050]

Wed, 05 September 2007 06:12

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I want to create a backup from my Oracle DB. I use the following script with a DOS command:
exp userid=system/manager file=c:\full_exp.dmp log=c:\full_exp.log compress=no full=yes statistics=none consistent=yes

This is not a (database) backup.

Quote:

The main problem is the new DB. We want to import the backup but the problem is...
When i want to start an export with the user "XYZ" i cant login with username / password

Export or import, be clear.

Quote:

Where is the problem?

I ask you the same question. I don't understand if you have a problem during export or import.

If you export with a DBA you have to import with a DBA.

Regards
Michel

Report message to a moderator

Re: Backup & Import Database | Problems with user-rules [message #265113 is a reply to message #265050]

Wed, 05 September 2007 08:01

nic.
Messages: 6
Registered: September 2007

Junior Member

I want to create a dump of the database.

This dump will be created by the user "system". I have another user, called "XYZ" which is a DBA. But i cant create a dump with this user!

I cant import the dump in the new DB because i must create the dump with the user "XYZ".

But i cant create a dump with this user. When i entered username and password the export stops cause UN & PW are wrong. But i have entered the UN & PW correct. So i cant create a valid dump to import it.

So, i think i have a problem with the export Cool

Have i to change some settings from the user "XYZ"?

Thank your for your help.

Report message to a moderator

Re: Backup & Import Database | Problems with user-rules [message #265117 is a reply to message #265113]

Wed, 05 September 2007 08:09

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I have another user, called "XYZ" which is a DBA. But i cant create a dump with this user!
...When i entered username and password the export stops cause UN & PW are wrong...

Copy and paste the command execution and not this... Please read and follow OraFAQ Forum Guide, especially what is said about IM speak.

Give a correct password.

Regards
Michel

Report message to a moderator

Re: Backup & Import Database | Problems with user-rules [message #265145 is a reply to message #265117]

Wed, 05 September 2007 09:41

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

We want to import them on another user (fe. "XYZ").

Use FROMUSER TOUSER clause in your import command.

and check the all related privileges for user through which you wanna IMPORT.

Report message to a moderator

Re: Backup & Import Database | Problems with user-rules [message #265216 is a reply to message #265145]

Wed, 05 September 2007 15:20

mson77
Messages: 208
Registered: August 2007
Location: Brazil

Senior Member

Hello nic,

1) Regarding user/password:
You have 2 DB. Let's say DB1 and DB2.
DB1 you have data in it;
DB2 is an empty database (for instance);

To access DB1 you have to have "user/passwd" of DB1. Use this credentials to make EXP (export);
To populate DB2 using IMP (import)... you have to have credential to access DB2... I mean: "user/passwd" of DB2. At this time... forget the "user/passwd" of DB1 because you are interacting with DB2 to import data in it.

2) Regarding your error...:
Did you do export successfully? What was the message after running the EXP command? Did you see the log file? Did you see content in the file DMP that has been created?

Are you able to connect via SQLPLUS on DB2 using "system" user?
Use this system/passwd to make the IMP.

And always... when you post your doubt... consider that the readers have first to understand your doubt/question to help you. As clear/full is the information you write... chances are bigger to get help.

Regards,

mson77

Report message to a moderator

Previous Topic:	What is the best way to load Excel sheet data in to Oracle database Tables?
Next Topic:	ORA-00942 (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 15 03:43:49 CDT 2024