Database Utilities (MOSC)

MOSC Banner

TTS IMPORT src-target - on same machine | How to remap file_names ? | REMAP_DATAFILE doesn't work

edited Jul 25, 2016 11:03AM in Database Utilities (MOSC) 3 commentsAnswered

pcs2 $ impdp PARFILE=dpump_exp_tts_cs_import.par

Import: Release 12.1.0.2.0 - Production on Mon Feb 15 14:15:56 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Username: dpump

Password:

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning option

ORA-39005: inconsistent arguments

ORA-39032: Parameter REMAP_DATAFILE is not supported in TRANSPORT_TABLESPACES jobs.

dumpfile=expdat.dmp

directory=data_pump_dir

transport_datafiles='/bckptest/tmp_pcs2/black_01.dbf',

'/bckptest/tmp_p.............................

REMAP_DATAFILE="'/oradb/cs/cs/data_01.dbf':'/NTF_LOGS_IDX_01.dbf'","'/oradb/cs/cs/TBS...........................

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center