oracle 基本练习 -凯发app官方网站

凯发app官方网站-凯发k8官网下载客户端中心 | | 凯发app官方网站-凯发k8官网下载客户端中心
  • 博客访问: 3977389
  • 博文数量: 536
  • 博客积分: 10470
  • 博客等级: 上将
  • 技术积分: 4825
  • 用 户 组: 普通用户
  • 注册时间: 2006-05-26 14:08
文章分类

全部博文(536)

文章存档

2024年(3)

2021年(1)

2019年(1)

2017年(1)

2016年(2)

2013年(2)

2012年(10)

2011年(43)

2010年(10)

2009年(17)

2008年(121)

2007年(252)

2006年(73)

相关博文
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·

分类: oracle

2007-08-02 18:54:44

sql*plus: release 9.2.0.4.0 - production on sun mar 18 11:58:12 2007

凯发app官方网站 copyright (c) 1982, 2002, oracle corporation. all rights reserved.

sql> connect /as sysdba

connected.

sql> shutdown immediate

database closed.

database dismounted.

oracle instance shut down.

sql> startup mount

oracle instance started.

total system global area 105978600 bytes

fixed size 453352 bytes

variable size 79691776 bytes

database buffers 25165824 bytes

redo buffers 667648 bytes

database mounted.

sql> alter database archivelog;

database altered.

sql> archive log list;

database log mode no archive mode

automatic archival disabled

archive destination c:/oracle/ora92/rdbms

oldest online log sequence 22

current log sequence 24

sql> alter system set log_archive_dest='/u1/oradata/arch';

system altered.

sql> alter system set log_archive_start=true scope=spfile;

system altered.

sql> shutdown immediate

database closed.

database dismounted.

oracle instance shut down.

sql> startup

oracle instance started.

total system global area 105978600 bytes

fixed size 453352 bytes

variable size 79691776 bytes

database buffers 25165824 bytes

redo buffers 667648 bytes

database mounted.

database opened.

sql> archive log list;

database log mode archive mode

automatic archival disabled

archive destination c:/oracle/ora92/database/archive

oldest online log sequence 22

next log sequence to archive 24

sql> alter system switch logfile;

system altered.

sql> alter system switch logfile;

system altered.

sql> alter system switch logfile;

阅读(2011) | 评论(0) | 转发(0) |
0

上一篇:compile linux kernel

下一篇:[转]oracle scn学习

给主人留下些什么吧!~~
")); function link(t){ var href= $(t).attr('href'); href ="?url=" encodeuricomponent(location.href); $(t).attr('href',href); //setcookie("returnouturl", location.href, 60, "/"); }
网站地图