>sqlplus /nolog >conn / as sysdba前提是你已经把数据库实例的服务启动,并且监听启动否则要这样 >sqlplus /nolog >start up >conn / as sysdba 如果还不能连,可能是你监听没有启动 >lsnrctl start >sqlplus /nolog >start up >conn / as sysdba
sqlplus username/password@servername as sysdba
CREATE SMALLFILE TABLESPACE "MYTABLESPACE" DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\myDatafile' SIZE 100M AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
conn user/password
>conn / as sysdba前提是你已经把数据库实例的服务启动,并且监听启动否则要这样
>sqlplus /nolog
>start up
>conn / as sysdba
如果还不能连,可能是你监听没有启动
>lsnrctl start
>sqlplus /nolog
>start up
>conn / as sysdba
sqlplus username/password@servername as sysdba
CREATE SMALLFILE TABLESPACE "MYTABLESPACE"
DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\myDatafile' SIZE 100M
AUTOEXTEND ON
NEXT 1024K
MAXSIZE UNLIMITED
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
在windows下也还好conn /as sysdba
net start oracleserice数据库名 //启动数据库服务
sqlplus scott/tiger
unix下就不知道了,不知道命令是不是一样的