Oracle常用命令大全（很有用，做笔记）

一、ORACLE的启动和关闭

1、在单机环境下

想要启动或关闭ORACLE系统必须首先切换到ORACLE用户，如下

su - oracle

a、启动ORACLE系统

oracle>svrmgrl

SVRMGR>connect internal

SVRMGR>startup

SVRMGR>quit

b、关闭ORACLE系统

oracle>svrmgrl

SVRMGR>connect internal

SVRMGR>shutdown

SVRMGR>quit

启动oracle9i数据库命令：

$ sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Oct 31

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect / as sysdba 

weibo.com/ttarticle/p/show?id=2309405100545542324358

weibo.com/ttarticle/p/show?id=2309405100545592655907

weibo.com/ttarticle/p/show?id=2309405100545655570838

weibo.com/ttarticle/p/show?id=2309405100545726873608

weibo.com/ttarticle/p/show?id=2309405100545772748977

weibo.com/ttarticle/p/show?id=2309405100545823342914

weibo.com/ttarticle/p/show?id=2309405100545877868761

weibo.com/ttarticle/p/show?id=2309405100545928200422

weibo.com/ttarticle/p/show?id=2309405100546049835282

weibo.com/ttarticle/p/show?id=2309405100546104361115

weibo.com/ttarticle/p/show?id=2309405100546163081428

weibo.com/ttarticle/p/show?id=2309405100546217607409

weibo.com/ttarticle/p/show?id=2309405100546284716316

weibo.com/ttarticle/p/show?id=2309405100546334785813

weibo.com/ttarticle/p/show?id=2309405100546393505826

weibo.com/ttarticle/p/show?id=2309405100546448031822

weibo.com/ttarticle/p/show?id=2309405100546498625611

weibo.com/ttarticle/p/show?id=2309405100546548957535

weibo.com/ttarticle/p/show?id=2309405100546599289067

weibo.com/ttarticle/p/show?id=2309405100546653815182

weibo.com/ttarticle/p/show?id=2309405100546712535485

weibo.com/ttarticle/p/show?id=2309405100546767061367

weibo.com/ttarticle/p/show?id=2309405100546817392939

weibo.com/ttarticle/p/show?id=2309405100546876113101

weibo.com/ttarticle/p/show?id=2309405100547341680643

weibo.com/ttarticle/p/show?id=2309405100547408527386

weibo.com/ttarticle/p/show?id=2309405100547463053327

weibo.com/ttarticle/p/show?id=2309405100547530424544

weibo.com/ttarticle/p/show?id=2309405100547597533194

weibo.com/ttarticle/p/show?id=2309405100547656253678

weibo.com/ttarticle/p/show?id=2309405100547718906041

weibo.com/ttarticle/p/show?id=2309405100547782082708

weibo.com/ttarticle/p/show?id=2309405100547849191658

weibo.com/ttarticle/p/show?id=2309405100547912106149

weibo.com/ttarticle/p/show?id=2309405100547983409353

weibo.com/ttarticle/p/show?id=2309405100548042129592

weibo.com/ttarticle/p/show?id=2309405100548100849834

weibo.com/ttarticle/p/show?id=2309405100548163764483

weibo.com/ttarticle/p/show?id=2309405100548222222391

weibo.com/ttarticle/p/show?id=2309405100548280942625

weibo.com/ttarticle/p/show?id=2309405100548331536688

weibo.com/ttarticle/p/show?id=2309405100548381606005

weibo.com/ttarticle/p/show?id=2309405100548448977217

weibo.com/ttarticle/p/show?id=2309405100548503503034

weibo.com/ttarticle/p/show?id=2309405100548558029083

weibo.com/ttarticle/p/show?id=2309405100548608360642

weibo.com/ttarticle/p/show?id=2309405100548658692319

weibo.com/ttarticle/p/show?id=2309405100548708761687

weibo.com/ttarticle/p/show?id=2309405100549552078960

weibo.com/ttarticle/p/show?id=2309405100549610799496

weibo.com/ttarticle/p/show?id=2309405100549682102580

weibo.com/ttarticle/p/show?id=2309405100549749211336

weibo.com/ttarticle/p/show?id=2309405100549812125940

weibo.com/ttarticle/p/show?id=2309405100549879234787

weibo.com/ttarticle/p/show?id=2309405100549937955102

weibo.com/ttarticle/p/show?id=2309405100550000869553

weibo.com/ttarticle/p/show?id=2309405100550529352106

weibo.com/ttarticle/p/show?id=2309405100550579683507

weibo.com/ttarticle/p/show?id=2309405100550646792535

weibo.com/ttarticle/p/show?id=2309405100550709707048

weibo.com/ttarticle/p/show?id=2309405100550776553528

weibo.com/ttarticle/p/show?id=2309405100550831341841

weibo.com/ttarticle/p/show?id=2309405100550894256438

weibo.com/ttarticle/p/show?id=2309405100550957170861

weibo.com/ttarticle/p/show?id=2309405100551019823217

weibo.com/ttarticle/p/show?id=2309405100551087194269

weibo.com/ttarticle/p/show?id=2309405100551158497630

weibo.com/ttarticle/p/show?id=2309405100551242121253

weibo.com/ttarticle/p/show?id=2309405100551309230149

weibo.com/ttarticle/p/show?id=2309405100551384989807

weibo.com/ttarticle/p/show?id=2309405100551447904471

weibo.com/ttarticle/p/show?id=2309405100551531790886

weibo.com/ttarticle/p/show?id=2309405100551594704924

weibo.com/ttarticle/p/show?id=2309405100551661551681

weibo.com/ttarticle/p/show?id=2309405100551716077584

weibo.com/ttarticle/p/show?id=2309405100551766409469

weibo.com/ttarticle/p/show?id=2309405100551833780241

weibo.com/ttarticle/p/show?id=2309405100551888306188

weibo.com/ttarticle/p/show?id=2309405100551947026514

weibo.com/ttarticle/p/show?id=2309405100552005746907

weibo.com/ttarticle/p/show?id=2309405100552068661772

weibo.com/ttarticle/p/show?id=2309405100552131575919

weibo.com/ttarticle/p/show?id=2309405100552198684740

weibo.com/ttarticle/p/show?id=2309405100552249016359

weibo.com/ttarticle/p/show?id=2309405100552316125329

weibo.com/ttarticle/p/show?id=2309405100552387428733

weibo.com/ttarticle/p/show?id=2309405100552441954332

weibo.com/ttarticle/p/show?id=2309405100552508801039

weibo.com/ttarticle/p/show?id=2309405100552559395342

weibo.com/ttarticle/p/show?id=2309405100552618115534

weibo.com/ttarticle/p/show?id=2309405100552685224182

weibo.com/ttarticle/p/show?id=2309405100552739749934