An entire schema, all tables and data?
Optimal way will almost always be by using Data Pump. You fan find our interface for that on the DBA panel. It requires server side access via database directories. If you don't have 'sys' privs, find someone who does.
You can also use the Database Copy or Database Export utilities. Database Copy could be quite slow....Database Export should work, but you'll be inserting rows 1 by 1 if you don't use the Loader format - which you'll want to do anyway if you have BLOBs in your tables.
We need to know more about your environment to know what would be 'optimal.' I think optimal would be again to find someone with the privs and have the use Data Pump.
Thank you for you're valuable input
What i did :
First of all exported Tables via Database Export (Tools --> Database Export)
Exported all objects,seqs,triggers etc.
Then, Run table script(step 1) using f5 and step 2 using f5.which works in my case without any errors takes almost 1 hour though.
Sys privs i can't have because it's server hosted environment other wise it would make my life more easier.
My environment have 100 tables,50 packages(seq,procedure,function everything included),30 triggers and half a million records.
Cool, so you're good to go then?
For sake of knowledge i would really like to know how would you deal with data export....(as a user which do not have sys prevs).
Like, what you export first and in which way.
Please let me know so i can learn it faster
1 person found this helpful
I'd ask the DBA to data pump it for me
if it were a small amount of data, i'd use the wizard to build import scripts
if it were a bigger amount, i'd ask the DBA to data pump it for me...or use SQL*loader
Great thanks for a quick response