Fzero
Advanced Member
- Joined
- Mar 9, 2010
- Messages
- 4,702
Do we have any in the house?
I am having a bit of a problem with the Data Pump commands, specifically with what it does to my system user login afterwards -- Changing the password I think.
I've set up my import dir in SQLPLUS [MyIMPdir] and given permissions to it.
I was then using the following string to import:
This was importing from theses schemas, but was omitting any tables which had no records, which causes a problem, I need to import all the tables regardless if they contain records or not.
So, I tried the below string, which I believe brings in all tables and schemas, as I am not defining specific ones.
Problem with this method though... My system user login seems to get corrupt/changed.
After import, I try to connect to the database via SQLPLUS with my system login and it states the login is incorrect.
I then had to use CMD to run SQL in SQLPLUS as sysdba and change my password back for user system.
Not ideal obviously.
I've no idea why this is happening.
Anyone able to explain why my login is changed, or how I should be running the IMPDP command so that all tables are imported, even those with no records belonging to them ... without upsetting my system user password?
Been reading some Oracle sites but can't see what I am doing wrong, yet sure I'm not meant to be needing to reset my password...
Am I going wrong by using the user system to run this?
Cheers for any help, save me registering on an Oracle help forum hopefully
I am having a bit of a problem with the Data Pump commands, specifically with what it does to my system user login afterwards -- Changing the password I think.
I've set up my import dir in SQLPLUS [MyIMPdir] and given permissions to it.
I was then using the following string to import:
impdp system/[MyPassword]@[MyDatabaseName] directory=[MyIMPdir] dumpfile=MyBackupDump.dmp schema=user1,user2
This was importing from theses schemas, but was omitting any tables which had no records, which causes a problem, I need to import all the tables regardless if they contain records or not.
So, I tried the below string, which I believe brings in all tables and schemas, as I am not defining specific ones.
impdp system/[MyPassword]@[MyDatabaseName] directory=[MyIMPdir] dumpfile=MyBackupDump.dmp
Problem with this method though... My system user login seems to get corrupt/changed.
After import, I try to connect to the database via SQLPLUS with my system login and it states the login is incorrect.
I then had to use CMD to run SQL in SQLPLUS as sysdba and change my password back for user system.
Not ideal obviously.
I've no idea why this is happening.
Anyone able to explain why my login is changed, or how I should be running the IMPDP command so that all tables are imported, even those with no records belonging to them ... without upsetting my system user password?
Been reading some Oracle sites but can't see what I am doing wrong, yet sure I'm not meant to be needing to reset my password...
Am I going wrong by using the user system to run this?
Cheers for any help, save me registering on an Oracle help forum hopefully
Last edited by a moderator: