Home » RDBMS Server » Backup & Recovery » small doubts on export/import
icon4.gif  small doubts on export/import [message #220224] Mon, 19 February 2007 11:55 Go to next message
Messages: 50
Registered: December 2006
Location: bangalore
hai to every one,

i am performing loading lot of data in my tables. so i am doing like this for fast loading.

dorp index
load data
recrate the index

i am ok with drop index and load data. but i am confused how to recreate all indexes.

how can i do it.

my thought is can i crate script for all index and run that scrit after loading the data.

i am working in linux. can any one send me reply as soon as possible. or any better idea recreating index

Re: small doubts on export/import [message #220235 is a reply to message #220224] Mon, 19 February 2007 13:40 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
There is no need for another script.
First import only data no constraints/indexes.
Then import only constraints/indexes no data.

imp user/pass fromuser=user_a touser=user_b rows=y constraints=n indexes=n
imp user/pass fromuser=user_a touser=user_b rows=n constraints=y indexes=y

I have no idea how many times i have asked you to search the forum before posting.
>> can any one send me reply as soon as possible
Because if you are so demanding, you should first show some effort.
Fact is, most of the questions asked are already been answered in form or another.

[Updated on: Mon, 19 February 2007 13:46]

Report message to a moderator

Previous Topic: Backup error RMAN-03009
Next Topic: Importing only tables from the dump file
Goto Forum:

Current Time: Tue Jul 25 10:00:26 CDT 2017

Total time taken to generate the page: 0.14280 seconds