Home » RDBMS Server » Backup & Recovery » Question releted to Export of full Database
Question releted to Export of full Database [message #121220] Thu, 26 May 2005 23:53 Go to next message
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
Re: Question releted to Export of full Database [message #121223 is a reply to message #121220] Fri, 27 May 2005 00:17 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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
Re: Question releted to Export of full Database [message #121357 is a reply to message #121223] Fri, 27 May 2005 14:29 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Thanks you for your reply

From:- Sunilkumar
Previous Topic: Database Cloning
Next Topic: RMAN Maintenance
Goto Forum:
  


Current Time: Thu Mar 28 05:24:16 CDT 2024