oracle的开启和关闭

登录

sqlplus "/as sysdba"

——————————————

关闭模型

1.shutdown immediate;

——————————————————

2.startup 开启状态

nomount --> mount -->open

————————————————————

确认是否正常

select name,open_mode from v$database;

select instance_name,status from v$instance;

————————————————————————

查看启动日志 找文件alert_xxxx查看启动停止过程可以

show parameter dump

————————————————————————————

网页创建

确定即可

可以编辑修改

cmd 在写字板写

创建表空间    （off可以关掉自动扩展）

CREATE TABLESPACE scdata01

        LOGGING

        DATAFILE  'E:\oracledata\oracled\db01\scdata01.ora' SIZE 10M AUTOEXTEND

        ON NEXT   10240K EXTENT MANAGEMENT  LOCAL SEGMENT SPACE  

        MANAGEMENT  AUTO;

CREATE TABLESPACE scdata02

        LOGGING

        DATAFILE  'E:\oracledata\oracled\db01\scdata02.ora' SIZE 10M AUTOEXTEND

        ON NEXT   10240K EXTENT MANAGEMENT  LOCAL SEGMENT SPACE  

        MANAGEMENT  AUTO;

查看 select * from v$tablespace;

_____________

删除  drop tablespace scdata01 including contents and datafiles;

___________

创建用户 

CREATE USER scuser PROFILE "DEFAULT"

IDENTIFIED BY scuser DEFAULT TABLESPACE scdb02

TEMPORARY TABLESPACE TEMP

ACCOUNT UNLOCK;

GRANT DBA TO scuser;

——————————————————————

连接

conn scuser/scuser;

创建数据表

create table table01( ID  NUMBER(12),C_DATE DATE);

______

查看表结构   desc table01;

插入数据

insert into table01 values(1,sysdate);

insert into table01 values(2,sysdate);

insert into table01 values(3,sysdate);

insert into table01 values(4,sysdate);

insert into table01 values(5,sysdate);

commit;