升级ORACLE

 

C:/Documents and Settings/Administrator>cd c:/oraclexe

 

C:/oraclexe>cd apex

 

C:/oraclexe/apex>sqlplus /nolog;

 

 

C:/oraclexe/apex>sqlplus /nolog

 

SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 10月 21 21:10:35 2008

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

SQL> conn  /as sysdba;

已连接。

 

SQL> @ apxldimg.sql C:/oraclexe;

 

PL/SQL 过程已成功完成。

 

原值    1: create directory APEX_IMAGES as '&1/apex/images'

新值    1: create directory APEX_IMAGES as 'C:/oraclexe/apex/images'

 

目录已创建。

 

 

PL/SQL 过程已成功完成。

 

 

PL/SQL 过程已成功完成。

 

 

提交完成。

 

计时: Load Images

已用时间:  00: 02: 00.68

 

目录已删除。

 

SQL> define ta_user = school

SQL>

SQL> -- DROP USER &ta_user CASCADE;

SQL>

SQL> CREATE USER &ta_user IDENTIFIED BY admin;

原值    1: CREATE USER &ta_user IDENTIFIED BY admin

新值    1: CREATE USER school IDENTIFIED BY admin

 

用户已创建。

 

SQL>

SQL> GRANT connect,resource TO &ta_user;

原值    1: GRANT connect,resource TO &ta_user

新值    1: GRANT connect,resource TO school

 

授权成功。

 

SQL>

SQL> GRANT CREATE DATABASE LINK, CREATE MATERIALIZED VIEW TO &ta_user;

原值    1: GRANT CREATE DATABASE LINK, CREATE MATERIALIZED VIEW TO &ta_user

新值    1: GRANT CREATE DATABASE LINK, CREATE MATERIALIZED VIEW TO school

 

授权成功。

 

SQL>

SQL> GRANT CREATE PROCEDURE, CREATE PUBLIC SYNONYM TO &ta_user;

原值    1: GRANT CREATE PROCEDURE, CREATE PUBLIC SYNONYM TO &ta_user

新值    1: GRANT CREATE PROCEDURE, CREATE PUBLIC SYNONYM TO school

 

授权成功。

 

SQL>

SQL> GRANT CREATE ROLE, CREATE SEQUENCE TO &ta_user;

原值    1: GRANT CREATE ROLE, CREATE SEQUENCE TO &ta_user

新值    1: GRANT CREATE ROLE, CREATE SEQUENCE TO school

 

授权成功。

 

SQL>

SQL> GRANT CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIE

W TO &ta_user;

原值    1: GRANT CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREA

TE VIEW TO &ta_user

新值    1: GRANT CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREA

TE VIEW TO school

 

授权成功。

 

SQL>