Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Ask DBA › Question Id: 3985 | Permalink

Schema level exprt and import

Question ID: 3985
Created By: 2010-MAR-28 09:32:30 [Singireddidba]
Updated By: 2010-JUL-08 13:28:52 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
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.