Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.

C:\Documents and Settings\zhangyouhai>set oracle_sid=zyh

C:\Documents and Settings\zhangyouhai>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 10月 11 17:17:54 2012

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

连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select segment_name from dba_segments where tablesapce_name='TEST';
select segment_name from dba_segments where tablesapce_name='TEST'
                                            *
第 1 行出现错误:
ORA-00904: "TABLESAPCE_NAME": 标识符无效

SQL> select segment_name from dba_segments where tablespAce_name='TEST';

SEGMENT_NAME
--------------------------------------------------------------------------------
TEST

SQL> desc mcsmaster.test
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------
 OBJECT_NAME                                        VARCHAR2(128)
 SUBOBJECT_NAME                                     VARCHAR2(30)
 OBJECT_ID                                          NUMBER
 DATA_OBJECT_ID                                     NUMBER
 OBJECT_TYPE                                        VARCHAR2(19)
 CREATED                                            DATE
 LAST_DDL_TIME                                      DATE
 TIMESTAMP                                          VARCHAR2(19)
 STATUS                                             VARCHAR2(7)
 TEMPORARY                                          VARCHAR2(1)
 GENERATED                                          VARCHAR2(1)
 SECONDARY                                          VARCHAR2(1)
 NAMESPACE                                          NUMBER
 EDITION_NAME                                       NUMBER

SQL> select count(*) from mcsmaster.test;

  COUNT(*)
----------
      2587

SQL> alter tablespace test offline;

表空间已更改。

SQL> select name from dba_data_files;
select name from dba_data_files
       *
第 1 行出现错误:
ORA-00904: "NAME": 标识符无效

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSTEM01.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSAUX01.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\UNDOTBS01.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\USERS01.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_DATA01.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_IDX01.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_DATA02.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_IDX02.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSTEM02.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSAUX02.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_DATA03.DBF

FILE_NAME
--------------------------------------------------------------------------------
D:\APP\ADMINISTRATOR\ORADATA\zyh\TEST.DBF

已选择12行。

SQL> alter datbase rename datafile 'D:\APP\ADMINISTRATOR\ORADATA\zyh\TEST.DBF' to 'D:\APP\ADMINISTRATOR\ORADATA\TEST.DBF';
alter datbase rename datafile 'D:\APP\ADMINISTRATOR\ORADATA\zyh\TEST.DBF' to 'D:\APP\ADMINISTRATOR\ORADATA\TEST.DBF'
      *
第 1 行出现错误:
ORA-00940: 无效的 ALTER 命令

SQL> alter database rename datafile 'D:\APP\ADMINISTRATOR\ORADATA\zyh\TEST.DBF' to 'D:\APP\ADMINISTRATOR\ORADATA\TEST.DBF';
alter database rename datafile 'D:\APP\ADMINISTRATOR\ORADATA\zyh\TEST.DBF' to 'D:\APP\ADMINISTRATOR\ORADATA\TEST.DBF'
                      *
第 1 行出现错误:
ORA-02231: ALTER DATABASE 选项缺失或无效

SQL> alter database rename  'D:\APP\ADMINISTRATOR\ORADATA\zyh\TEST.DBF' to 'D:\APP\ADMINISTRATOR\ORADATA\TEST.DBF';
alter database rename  'D:\APP\ADMINISTRATOR\ORADATA\zyh\TEST.DBF' to 'D:\APP\ADMINISTRATOR\ORADATA\TEST.DBF'
                       *
第 1 行出现错误:
ORA-02231: ALTER DATABASE 选项缺失或无效

SQL> alter database rename file 'D:\APP\ADMINISTRATOR\ORADATA\zyh\TEST.DBF' to 'D:\APP\ADMINISTRATOR\ORADATA\TEST.DBF';

数据库已更改。

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSTEM01.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSAUX01.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\UNDOTBS01.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\USERS01.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_DATA01.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_IDX01.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_DATA02.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_IDX02.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSTEM02.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSAUX02.DBF
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_DATA03.DBF

FILE_NAME
--------------------------------------------------------------------------------
D:\APP\ADMINISTRATOR\ORADATA\TEST.DBF

已选择12行。

SQL> alter tablespace test online;

表空间已更改。

SQL> desc dba_data_files
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------
 FILE_NAME                                          VARCHAR2(513)
 FILE_ID                                            NUMBER
 TABLESPACE_NAME                                    VARCHAR2(30)
 BYTES                                              NUMBER
 BLOCKS                                             NUMBER
 STATUS                                             VARCHAR2(9)
 RELATIVE_FNO                                       NUMBER
 AUTOEXTENSIBLE                                     VARCHAR2(3)
 MAXBYTES                                           NUMBER
 MAXBLOCKS                                          NUMBER
 INCREMENT_BY                                       NUMBER
 USER_BYTES                                         NUMBER
 USER_BLOCKS                                        NUMBER
 ONLINE_STATUS                                      VARCHAR2(7)

SQL> select tablespace_name,file_name from dba_data_files;

TABLESPACE_NAME
------------------------------------------------------------
FILE_NAME
--------------------------------------------------------------------------------
SYSTEM
D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSTEM01.DBF

SYSAUX
D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSAUX01.DBF

UNDOTBS1
D:\APP\ADMINISTRATOR\ORADATA\zyh\UNDOTBS01.DBF

TABLESPACE_NAME
------------------------------------------------------------
FILE_NAME
--------------------------------------------------------------------------------
USERS
D:\APP\ADMINISTRATOR\ORADATA\zyh\USERS01.DBF

johnny_DATA
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_DATA01.DBF

johnny_IDX
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_IDX01.DBF

TABLESPACE_NAME
------------------------------------------------------------
FILE_NAME
--------------------------------------------------------------------------------
johnny_DATA
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_DATA02.DBF

johnny_IDX
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_IDX02.DBF

SYSTEM
D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSTEM02.DBF

TABLESPACE_NAME
------------------------------------------------------------
FILE_NAME
--------------------------------------------------------------------------------
SYSAUX
D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSAUX02.DBF

johnny_DATA
D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_DATA03.DBF

TEST
D:\APP\ADMINISTRATOR\ORADATA\TEST.DBF

已选择12行。

SQL> col tablespace_name for a60
SQL> col file_name for a60
SQL> set linesize 200
SQL> /

TABLESPACE_NAME                                              FILE_NAME
------------------------------------------------------------ ------------------------------------------------------------
SYSTEM                                                       D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSTEM01.DBF
SYSAUX                                                       D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSAUX01.DBF
UNDOTBS1                                                     D:\APP\ADMINISTRATOR\ORADATA\zyh\UNDOTBS01.DBF
USERS                                                        D:\APP\ADMINISTRATOR\ORADATA\zyh\USERS01.DBF
johnny_DATA                                                    D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_DATA01.DBF
johnny_IDX                                                     D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_IDX01.DBF
johnny_DATA                                                    D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_DATA02.DBF
johnny_IDX                                                     D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_IDX02.DBF
SYSTEM                                                       D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSTEM02.DBF
SYSAUX                                                       D:\APP\ADMINISTRATOR\ORADATA\zyh\SYSAUX02.DBF
johnny_DATA                                                    D:\APP\ADMINISTRATOR\ORADATA\zyh\johnny_DATA03.DBF

TABLESPACE_NAME                                              FILE_NAME
------------------------------------------------------------ ------------------------------------------------------------
TEST                                                         D:\APP\ADMINISTRATOR\ORADATA\TEST.DBF

已选择12行。

SQL> select count(*) from mcsmaster.test;

  COUNT(*)
----------
      2587

SQL>