Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options questions only not deleted user 172183

For questions about the Oracle Data Pump export (invoked with the expdp command). Use together with the [oracle] tag, and include the appropriate version tag, such as [oracle-12c]. If the question applies to both the impdp and expdp commands, do not use this tag; use [datapump] tag instead.

1 vote
4 answers
18k views

How to use / as sysdba in pluggable database?

I tried something like this: userid=\"/ as sysdba@mypdb_oracle_net\" but it does not work. expdp userid=\"/ as sysdba@mypdb_oracle_net\" dumpfile=full_%U.exp logfile=full.log directory=teste full=y parallel …
Astora's user avatar
  • 801
0 votes
0 answers
524 views

ORA-01466: unable to read data - table definition has changed

What happen when is done a import from a export with this erro? I have a table that every day is altered the structure during the consistent export (flashback_time=systimestamp) and I always receive t …
Astora's user avatar
  • 801
0 votes
1 answer
932 views

Datapump not working in RAC environment

Some minutes ago I've tried to do an export but I get the following error (AIX system): Additional information: 3 ORA-31693: Table data object "XX"."TABLE_NAME" failed to load/unload and is being ski …
Astora's user avatar
  • 801
0 votes
1 answer
262 views

Why expdp does not include identified by statement?

I have the following error when I do a impdp (from a pdb in a 12c to 11g. I also used the parameter version=11.2.0) IMPDP LOG: ORA-01938: IDENTIFIED BY must be specified for CREATE USER Failing sql …
Astora's user avatar
  • 801
1 vote
1 answer
390 views

Does the target database need to have the same structure of the source database before to us...

When I do a import from another database have I need the same estruture of the source database in the target database? For example, if my source database use ASM and my target database no, what have I …
Astora's user avatar
  • 801