- 数据库连接 PLSQL Developer Database: 130.200.81.190:1521/dia
EAS后台快捷键:ctrl+shift+Q
查看用户和默认表空间的关系。
select username,default_tablespace from dba_users;
select * from dba_users;
select TABLE_NAME,TABLESPACE_NAME
FROM USER_TABLES where TABLE_NAME like '%USER%'
select * from T_PM_USER where fnumber like 'administrator'
select fpassword from T_PM_USER where fnumber like 'administrator'
bigtidekd EFSUth67/LIkJHGnKvBGgA==
bigtide2012 shjqSnCv3CMqQgl/MgKKug==
SYS 5463C0B6E6EF7B46
SYSTEM 77526D5AD5F4AE68
BIGTIDE2012 EFBD4E02799B507E
BIGTIDEKD C1017AC7E50A7423
SONGS FFBFDC7747EDA20D
SYSMAN C12F29A4EB5FADBA
localhost 130.200.81.190:1521/dia
SYS 3C783CF23A9BD18B
SYSTEM C12F29A4EB5FADBA
select fpassword from T_PM_USER where fnumber like 'administrator' for update
update T_PM_USER set fpassword='EFSUth67/LIkJHGnKvBGgA=='
查看用户和默认表空间的关系。
select username,default_tablespace from dba_users;
exp bigtide2012/bigtide owner=bigtide2012 file=/u01/app/oracle/10G/bigtide2012.dmp log=/u01/app/oracle/10G/bigtide2012.log buffer=1000000 feedback=50000 compress=n
imp bigtide2012/shlzghli touser=bigtide2012 fromuser=bigtide2012 file=D:\10G\bigtide2012.dmp log = D:\10G\bigtide2012.log buffer=1000000 feedback=50000
2、查询数据库对应实体的表名:
select FName as 实体名,FFullName as 类名, FAlias as 别名,FTableName as 数据库表名 from T_ISQL_EntityInfoIndex where FAlias like '%销售订单%'