OraFAQ Forum: Backup & Recovery » Question releted to Export of full Database

Home » RDBMS Server » Backup & Recovery » Question releted to Export of full Database

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

Question releted to Export of full Database [message #121220]

Thu, 26 May 2005 23:53

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi

My question is as below

[1] If i export the full database and try to import on another database then on another database do i have to create all user schema which was present on the database from were i had doen export or just i have to do import ?

Note:- I want to do export and import on same version of oracle

From :- Sunilkumar Mishra

Report message to a moderator

Re: Question releted to Export of full Database [message #121223 is a reply to message #121220]

Fri, 27 May 2005 00:17

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

The import utility (with FULL=yes) will attempt to create all the required Oracle users and roles before importing the data.

This can be confirmed with a quick test, or by reading the Oracle Utilities Guide.

Best regards.

Frank

Report message to a moderator

Re: Question releted to Export of full Database [message #121357 is a reply to message #121223]

Fri, 27 May 2005 14:29

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

Thanks you for your reply

From:- Sunilkumar

Report message to a moderator

Previous Topic:	Database Cloning
Next Topic:	RMAN Maintenance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 29 10:26:16 CDT 2025