RE: "Best" way to copy schema data to another DB
- From: Ian Cary <ian.cary@xxxxxxxxxxxxxx>
- To: mark.teehan@xxxxxxxxxxxxxxxxx
- Date: Wed, 14 Apr 2010 10:40:23 +0100
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.
>
>
--
//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
===============================================================================
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
