| Huge database [message #370085] |
Tue, 12 December 2000 22:10  |
RYAN
Messages: 22
Registered: December 2000
|
Junior Member |
|
|
I have a situation that I must deal with many huge tables. It took so long for me to run my script which contains several cursors. Since I am relatively new in this subject, I am totally dumb. Please someone give me some tips to quicken my script running. Any tips are welcome.
Thx! =P
|
|
|
|
| Re: Huge database [message #370122 is a reply to message #370085] |
Mon, 18 December 2000 17:54  |
Vince
Messages: 11
Registered: December 2000
|
Junior Member |
|
|
Hi Ryan!!
If you are going to do this on a long term basis, then these points could be handy!!!
Before Loading the Tables, make sure you drop the Indexes, Disable Foreign Key constraints, Disable Triggers,Packages etc!!!
After Loading Tables you can Enable or Create Them.
Also if you are using SQL *LOADER to load these things, you might have to use the DIRECT path than the CONVENTIONAL path!!, you can also run Simultaneous scripts, by diving the Tables into two or three scripts!!!
Hope this helps!!!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
