 small doubts on export/import [message #220224] |
Mon, 19 February 2007 11:55  |
pavan27
Messages: 50
Registered: December 2006
Location: bangalore
|
Member |
|
|
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
thanks
pavan
|
|
|
|
| Re: small doubts on export/import [message #220235 is a reply to message #220224] |
Mon, 19 February 2007 13:40  |
 |
Mahesh Rajendran
Messages: 10708
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
PS:
I have no idea how many times i have asked you to search the forum before posting.
Why?
>> 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
