Home » RDBMS Server » Server Utilities » EXPORT AND IMPORT (ORACLE 9.2)
EXPORT AND IMPORT [message #383985] Sun, 01 February 2009 06:47 Go to next message
eml2raghu
Messages: 11
Registered: April 2007
Location: CHENNAI
Junior Member
Hi, Can anyone help me how to import the entire database. I have an old database, which is having some schemas. Now I want to remove all the schemas and create a new database which is exactlly same as the new one, which is in the form of dump. I have a rough idea on this, but not clear idea. Can someone help me by providing the steps i have to do in order.

Thanks in advance
Re: EXPORT AND IMPORT [message #384000 is a reply to message #383985] Sun, 01 February 2009 08:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OracleŽ Database Utilities

Regards
Michel
Re: EXPORT AND IMPORT [message #384807 is a reply to message #383985] Thu, 05 February 2009 04:48 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I can't understand what you're trying to do.
Quote:
I have an old database, which is having some schemas
Ok - you have a database.
Quote:
Now I want to remove all the schemas
DROP USER <username> CASCADE; would seem to be a useful command.
and create a new database which is exactlly same as the new one, which is in the form of dump
I presume by 'Create a new database' you mean 'import a dump file into the old database' - am I right?

what sort of Export was taken?
Was it for the whole Db, or just the schemas that you want to import?
Was the soure database the same version as the database that you're trying to import into?
Previous Topic: ORACLE DATABASE EXPORT/IMPORT
Next Topic: converting oracle.ora file
Goto Forum:
  


Current Time: Mon Dec 05 07:07:27 CST 2016

Total time taken to generate the page: 0.16315 seconds