RE: "Best" way to copy schema data to another DB

Don't forget the datpump API though , which allows you port data directly
from one database to another without needing a dump file at all and can all
be done via pl/sql.

Cheers,

Ian



|---------+----------------------------->
|         |           mark.teehan@credit|
|         |           -suisse.com       |
|         |           Sent by:          |
|         |           oracle-l-bounce@fr|
|         |           eelists.org       |
|         |                             |
|         |                             |
|         |           14/04/2010 07:57  |
|         |           Please respond to |
|         |           mark.teehan       |
|         |                             |
|---------+----------------------------->
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                                                     |
  |       To:       oracle-l@xxxxxxxxxxxxx                                      
                                                                     |
  |       cc:                                                                   
                                                                     |
  |       Subject:  RE: "Best" way to copy schema data to another DB            
                                                                     |
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|





Slightly OT but another major difference between exp and expdp: you need
database server access for expdp.
With exp developers can run exp/imp to refresh tables via their
desktops; they lose this ability with data pump unless they have a login
to the database server - which is not allowed in many shops. I think
that similar to bcp for sybase, exp is one of Oracle's crown jewels and
DP is really quite a different utility. I think both are needed.

Rgds
Mark


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Yechiel Adar
Sent: 14 April 2010 14:35
To: rjoralist@xxxxxxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: "Best" way to copy schema data to another DB

According to: http://yong321.freeshell.org/oranotes/DataPump.txt by Yong
Huang.

If the table was in nologging then impdp do not generate redo log.

so:
1) Impdp structure only.
2) Alter all tables to nologging.
3) Impdp with ignore=y with network_link.
4) Alter all tables back to logging.

Use at your own risk. : I did not check that what he writes is correct.

Adar Yechiel
Rechovot, Israel



Rich Jesse wrote:
> I've alsotried using the NETWORK_LINK option of impdp, but it refuses
to use APPEND.
>
>
--
http://www.freelists.org/webpage/oracle-l



===============================================================================

Please access the attached hyperlink for an important electronic
communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
===============================================================================


--
http://www.freelists.org/webpage/oracle-l






For the latest data on the economy and society consult National Statistics at 
http://www.ons.gov.uk

*********************************************************************************


Please Note:  Incoming and outgoing email messages are routinely monitored for 
compliance with our policy on the use of electronic communications
*********************************************************************************


Legal Disclaimer  :  Any views expressed by the sender of this message are not 
necessarily those of the Office for National Statistics
*********************************************************************************


The original of this email was scanned for viruses by the Government Secure 
Intranet virus scanning service supplied by Cable&Wireless in partnership with 
MessageLabs. (CCTM Certificate Number 2009/09/0052.) On leaving the GSi this 
email was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or 
recorded for legal purposes.
--
http://www.freelists.org/webpage/oracle-l


Other related posts: