oracle 小问题

1.登录问题

SQL> conn / as sysdba;
Connected to an idle instance.

说明数据没有启动

可以使用startup 命令启动数据 后再连接。

SQL> startup nomount
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size                  2217952 bytes
Variable Size             469764128 bytes
Database Buffers          360710144 bytes
Redo Buffers                2412544 bytes
SQL> conn / as sysdba;
Connected.

2.查看某张表，占用空间的大小

select  segment_name,bytes/1024/1024 from user_segments where segment_name = tablename;