我试图关闭系统,然后我想挂载它。我试过这样做:Database closed.ORACLE instance shut down.ORA-12514: TNS:listener does not currently know of service requested in connect descriptorORA-24324: service handle not initialized
ORA-
我已经这样定义了模式CREATE TABLE session(sid vchar(100) PRIMARY KEY ASC, msgid vchar(100), updatedint(32), ip vchar(40), port int(32));
但是当我使用select * from session when sid='xxxxx'查询数据库时,却没有答案。SINKSESSIONID0153FD46440001|000000000000001542|1409
我正在使用sql server 2008...我想要一个sql查询来查找由特定登录用户创建的不同数据库?例如。假设user1已经创建了数据库db1和db2。user2是由数据库db3和db4创建的。则查询应给出结果db1,对于user1和db3为db2,对于user2为db4 ...
另外,我想查询获得特定用户的特权?
我们已经导出了Microsoft 2014服务器,并重建了主数据库。用户现在失踪了,所以我们需要检测孤立的用户。%27s%20in%20the%20user...%20More%20SELECT dp.type_desc, dp.SID, dp.name AS user_nameFROM sys.database_principals AS dp ON dp.SID = sp.SID</em