Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

how to recreate database and import my data.

SOLVED
Go to solution
Charles Egbon
Regular Advisor

how to recreate database and import my data.

Hi Guys,
I am running oracle 10.1.0.2.0 on HPUX 11i. I want to export my data, drop my existing database, recreate the database and import my data. I like to request detailed action steps on how I can achieve it.

Thanks.

Charles.
3 REPLIES
Hein van den Heuvel
Honored Contributor

Re: how to recreate database and import my data.

This is strictly and only an Oracle question and thus probably better asked in an Oracle Forum.

It is also a very generic and common question, so PLEASE look around for earlier answers and then ask for specific details as they might appy to your setup.

"detailed action steps" can be found in the Oracle (online) documentation as well as earlier replies. Search for it, Read it!

You may want to google for (quoted) "control file to trace" besides the obvious : +oracle +recreate +database

Basic method:
- document al steps as you go/learn!
- grab control file definition
- export (all)
- recreate with control file SQL
- apply catalog.sql, pupbld and such
- load yoru data (no index is my preference)
- create your indexes


Good luck!

Hein.
Yogeeraj_1
Honored Contributor

Re: how to recreate database and import my data.

hi,

If you have enough resources, you can as well create another database on the same server and import the data before you actually drop the old database.

Anyway,

1. Create a new database
use the dbca utility

2. Import and export data
Questions: how many custom schemas do you have?
(if you have only a few, it would be much easier to perform the import and export)

revert
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Nyck_1
Super Advisor
Solution

Re: how to recreate database and import my data.

Below is the kinda syntax that I use:-

Oracle database dumping & loading
1. Shut down all instances associated with the database.
2. Start up the database so that it can be accessed only by DBAs as in the following example:
SVRMGR> STARTUP RESTRICT OPEN
3. Perform a full database export (FULL=Y) to backup the entire database.
source .cshrc920
Oracle 9.2.0 Server
ORACLE_HOME = /ora1/app/oracle/product/9.2.0
--------------------------------------------------

setenv ORACLE_SID BTDADMFX
exp system/T843BTDADMFX FULL=y FILE=/home/nick/exp-BTDADMFX.dmp LOG=/home/nick/exp-BTDADMF
X.log

imp system/T843BTDADMFX FULL=y IGNORE=y COMMIT=N FILE=/home/nick/exp-BTDADMFX.dmp

So you need to take a full dump of your database first, then drop it, create the new database and then load up the dump that you took before you dropped the original database