Is there anything else that i can do which could resolve this problem. Asked 4 years, 1 month ago. Hi, The user is in the same database. Do more with. Sign up using Email and Password.
you can remap schema while you import dump file.
to supply additional quotation marks on the command line, Oracle recommends the use of parameter files. › /12 › oraschema-was-not-fo.
Basically, I was trying to import a schema, JAY, to my current database as JOE schema. [[email protected]~] impdp [email protected]
You might be spreading security…. And if that isn't the case I'd still concentrate on getting rid of or renaming the schema with the trailing space.
I have run the commands you suggested and the user is in the database. Will revert tomorrow.
Toggle search. December 02,
JD ACCOUNTS OFFICER COVER
|Even though I have the grant, this is saying I need the role.
Video: Impdp ora 39165 schematic How to perform Remap Schema Export & Import utility in Oracle Database. /* Step By Step /*
Select all Open in new window. DMP file if you use linux If not insert the correct schema name.
Video: Impdp ora 39165 schematic ORA-39002: invalid operation ORA-39070: Unable to open the log file
The files from expdp are not readable by an editor.
ORA As you are now trying to import into a schema named "cata" you need to specify the So for your case: impdp system/[email protected]
This tool allows you to export all tables and content from one schema into an SQL file, which in turn can be imported into the schema you want.
Copying code from Stack Overflow?