• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 696
  • Last Modified:

DataPump in Network Mode (without creating tables, only populating?)

I am a fan of DataPump in Network Mode.  Typically I will execute something like the following,

impdp XXXX/XXXX@TARGET_DATABASE directory=dmpdir network_link=SOURCE_DB_LINK tables=TABLE1 TABLE2 TABLE3 remap_schema=DEVELOPMENT_SCHEMA:PROD_SCHEMA

I have a requirement to move a database to an environment where I do not have create privileges.  Is it possible to use DataPump in Network Mode for this task?

That is the question.  "Is it possible to use DataPump in Network Mode to move data from one database to another by specifying tables for inserting rather than specifying tables for creating and then inserting."

Thanks in advance.
0
donnatronious
Asked:
donnatronious
  • 2
1 Solution
 
it-rexCommented:

If a privileged user (e.g. SYSTEM) is exporting or importing data with the NETWORK_LINK parameter and is using a (public) database link that connects to a remote database as a non-privileged user (e.g. SCOTT), then the Import DataPump or Export DataPump job will fail with:

> impdp system/manager NOLOGFILE=y NETWORK_LINK=scott_pub_dblink \
SCHEMAS=scott REMAP_SCHEMA=scott:hugo  

Import: Release 10.2.0.3.0 - Production on Thursday, 23 August, 2007 11:49:30
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
ORA-31631: privileges are required
ORA-39149: cannot link privileged user to non-privileged user


0
 
donnatroniousAuthor Commented:
it-rex,

Thank you for the comment.  I do appreciate it.  Lets get back to the question.

"Is it possible to use DataPump in Network Mode to move data from one database to another by specifying tables for inserting rather than specifying tables for creating and then inserting?"
0
 
donnatroniousAuthor Commented:
it-rex,

Lets consider a situation where a privileged user is exporting or importing data with the NETWORK_LINK parameter and is using a (public) database link that connects to a remote database as a privileged user.

Given that scenario, is it possible to use DataPump to transfer data into tables that already exist, rather than create the tables?
0
 
schwertnerCommented:
You can export/import the structure of the tables only (ROWS=n parameter)

impdp
FILE=/u02/oradata/ora10g/EXPDAT.DMP
LOG=/u02/oradata/ora10g/IMPORT.LOG
FROMUSER=iself
TABLES=emp,dept
GRANTS=y
INDEXES=y
ROWS=n
CONSTRAINTS=y
IGNORE=y
COMMIT=y
RECALCULATE_STATISTICS=y
DATAFILES=n
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now