Expdp a user with the name
user_prd for example. I copied the dump file to another server, and I want to restore it with the name
remap_schema with no succes ( Im a SQL DBA, so it's hard to understand that schema is the name of the user, that is the database in SQL. I'm slowly learning )
I thought to rename the schema, but As said here, it's not a so good idea.
I read somewhere about
fromuser touser. Is this right?
I could use
remap_schema with users from inside the same server, like, there was the
user_prd, and I just created the
user_hom, using remap.
I'm trying this for now:
IMP SYSTEMUSER/PASS@TNS FILE=<myFile>.dmp fromuser=OriginalUser_prd touser=New_User_hom
bla bla bla IMP-0034 error