CODEWITHSUNDEEP
sqldatabaseoracle-databaseparametersimpdp
Blank
Blank

Reputation: 100

SQL - How to import a user as a new user with some tables

Hello beloved community,

Im trying to import an oracle database with the impdp command, and I want to import the already exported user A as User B with some specific tables. But I don't find any command line parameter for this operation.

Upvotes: 0

Views: 508

Answers (1)

Littlefoot
Littlefoot

Reputation: 143023

  • user A to user B: remap_schema
  • some specific tables: tables

For example:

impdp unb/pwb@db tables=usera.emp,usera.dept directory=expdir logfile=impdpab.log remap_schema=A:B

Upvotes: 1

Related Questions