This content has been marked as final. Show 15 replies
IMPORT:1 person found this helpful
Create an indexfile so that you can create indexes AFTER you have imported data. Do this by setting INDEXFILE to a filename and then import. No data will be imported but a file containing index definitions will be created. You must edit this file afterwards and supply the passwords for the schemas on all CONNECT statements.
Place the file to be imported on a separate physical disk from the oracle data files
Increase DB_CACHE_SIZE (DB_BLOCK_BUFFERS prior to 9i) considerably in the init$SID.ora file
Set the LOG_BUFFER to a big value and restart oracle.
Stop redo log archiving if it is running (ALTER DATABASE NOARCHIVELOG;)
Create a BIG tablespace with a BIG rollback segment inside. Set all other rollback segments offline (except the SYSTEM rollback segment of course). The rollback segment must be as big as your biggest table (I think?)
Use COMMIT=N in the import parameter file if you can afford it
Use STATISTICS=NONE in the import parameter file to avoid time consuming to import the statistics
Remember to run the indexfile previously created
Set the BUFFER parameter to a high value (e.g. 2Mb -- entered as an integer "2000000")
Set the RECORDLENGTH parameter to a high value (e.g. 64Kb -- entered as an integer "64000")
Use DIRECT=yes (direct mode export)
Stop unnecessary applications to free-up resources for your job.
If you run multiple export sessions, ensure they write to different physical disks.
DO NOT export to an NFS mounted filesystem. It will take forever.
This was a simple google.
bas karo yar...
not a good pactice.....
i hope u understand.....
What do you mean Niket? I did not get you.
that's for TSharma.....not for you.....
i think he correctly got me....
Bhaisaab, If other person does not know how to google tha what can I do. his question was not a rocket science. Little google would help.
donno why you always answer this guy's questions :-)
there are lots of threads in the forum...
and yes you need not to use three post you can edit a single post :-)
Nobody stopping anybody to answers any question buddy . I am answering other people answers too. And the reason I gave answer in separates tab so that it would be easy to read. Import on one and Export on one.
Edited by: TSharma on Jan 17, 2013 5:43 PM
keep it up..... :-)
Well, you could always format the post a little to emphasize that you are talking about two different points . Second , though it's easy to google but the best is not to do that and point the person to either the standard documentation or ask him to do some effort. The best way to help is to make the person more self-sufficient IMO.1 person found this helpful
Aman, I like to be specific other than pointing to documentation. Nobody likes to read big documentation for a small information unless somebody is totally free.1 person found this helpful
And it is definitely a no-no to quote other places like http://www.orafaq.com/wiki/Import_Export_FAQ without attribution as if they are your own words.
Its always helpful if you give what user asks not the whole documentation. Where I think I need to provide the full documentation I do and where I think I need to discuss, I discuss. So No offense buddy you do your way I will do mine. As long as we are helping others we are good.