Want to use Oracle exp export devices in the database, the users... Table, these are under I create user "dbo", but the use of dbo login always rejected, use the sysdba login after the export table always remind sys. Devices does not exist, such as ever understand bosses guidance,

CodePudding user response:

Have bosses to give directions,,,

CodePudding user response:

Tables=dbo. Devices, dbo. Users

CodePudding user response:

Exp system/PWD @ former file=E:/20201228. DMP tables=(DBO. DEVICES, DBO. USERS)

CodePudding user response:

reference really don't know what to take place on the second floor response:

tables=dbo. Devices, dbo. Users

I still have a problem, the dbo is my own to create a login name, under the sys can't find the dbo device list

CodePudding user response:

reference wyqxrj reply: 3/f

exp system/PWD @ former file=E:/20201228. DMP tables=(DBO. DEVICES, DBO. USERS)

There is a bit of a problem,,,,

CodePudding user response:

Select the owner from dba_segments where segment_name='DEVICES';
- see you under which user is this table

CodePudding user response:

refer to 6th floor takes really don't know what name response:

select the owner from dba_segments where segment_name='DEVICES';
- see you in this table is under which user

Is used when using exp command under dbo dbo login login always rejected

CodePudding user response:

Exp \ '/as sysdba \' file=c: \ 2020. DMP tables=DBO. DEVICES

CodePudding user response:

refer to the eighth floor takes really don't know what name response:

exp \ '/as sysdba \' file=c: \ 2020. DMP tables=DBO. DEVICES

Or not, I feel this problem is the need when entry of exp dbo when input user name and password login has been rejected and the system can normal login, but didn't have no way to export the table under the dbo, dbo account can normal login pl/SQL; Another problem is that I also try to use the tools of pl/SQL directly export table, but choose the current logged-in user cannot normal loading all of the tables, don't know is what reason,
Use the ef - Oracle) (dbo

CodePudding user response:

This command is ok, just your system user's password wrong

CodePudding user response:

The user to unlock
The ALTER USER DBO ACCOUNT UNLOCK;

CodePudding user response:

Unlock, then do the export

CodePudding user response:

The

references to the tenth floor wyqxrj response:

This command is ok, just mistyped your system password of user

I just tried it again the password should be nothing wrong with all of my password is 123456, I re-enter below 123456 is always be refused to log in, don't know what reason