Schema level exprt and import
|
11236
2010-MAR-28 09:32:30
|
|
User
|
|
|
Registered On: Feb 2010
Total Posts: 24
|
|
Hi Vitaily
What my question was,,,?
In my production server there is one schema called scott, under scott schema
there is 100GB of data , i want to export the 100GB data from production server
and import that data into Development server , to achieve this ...what are
steps i have to follow and Is there any prerequisites in the production and
server ?
|
11248
2010-MAR-31 20:18:24
|
|
Moderator
|
|
|
Registered On: Mar 2006
Total Posts: 292
|
|
It really depends -- there's no rule of thumb type of advice here. If the data
is all in one table then data pump or SQL Loader (sqlldr) is something to
consider. If the data is spread among the many tables then it doesn't really
matter.
I still use EXP/IMP sometimes to get the schema structure only (rows=N) and
then the data ... You then import the schema structure first and data last
(ignore=Y).
It's something you have to play with to see what is faster easier and more
appropriate for the scenario you face.
|
11554
2010-JUL-08 01:44:52
|
|
User
|
|
|
Registered On: Jul 2010
Total Posts: 7
|
|
Is there a way we can just export/import the datafiles (.dbf)?
|
11558
2010-JUL-08 13:28:52
|
|
Moderator
|
|
|
Registered On: Mar 2006
Total Posts: 292
|
|
> Is there a way we can just export/import the datafiles (.dbf)?
That's what RMAN is for -- it backups datafiles.
EXP/IMP is for specific schema/table/whole db structure (no data). EXP/IMP
should not be relied on for database backups. RMAN is for database backups.