8i 选择DBA Studio进入
9i 进入Enterprise Manager Console进入以后选择文件--〉将数据库添加到树
然后就能访问数据库了,不过只能用拥有DBA权限的人和拥有select any dictionary的用户才能登陆。连接的配置文件放在 $ORACLE_HOME/network/admin/tnsnames.ora里面
链接示例:
ora9i =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = ora9test))
)上面的 192.168.0.1 换成数据库所在的ip地址,1521换成实际的端口号(默认安装为1521),ora9test 换成service name
9i 进入Enterprise Manager Console进入以后选择文件--〉将数据库添加到树
然后就能访问数据库了,不过只能用拥有DBA权限的人和拥有select any dictionary的用户才能登陆。连接的配置文件放在 $ORACLE_HOME/network/admin/tnsnames.ora里面
链接示例:
ora9i =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = ora9test))
)上面的 192.168.0.1 换成数据库所在的ip地址,1521换成实际的端口号(默认安装为1521),ora9test 换成service name
select owner,segment_name,count(*) cnt from dba_extents
group by owner,segment_name having owner='SCOTT' order by cnt去看。
select table_name from user_tables;
select object_name||' '||object_type from user_objects;