《东软电子出版社》oracle数据库课后习题P148

Microsoft Windows [版本 6.1.7601]

版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:Userslf>set oracle_sid=books

C:Userslf>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on 星期日 4月 14 19:44:31 2013

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

连接到:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> create tablespaceindxdatafile 'F:oracleproduct10.2.0oradatabooksind

' size 30M extent management local autoallocate;

表空间已创建。

SQL>ed

已写入 file

1* create tablespace usertbs1 datafile 'F:oracleproduct10.2.0oradatabooks

' size 20M extent management local autoallocate

SQL> /

表空间已创建。

SQL>ed

已写入 file

1* create tablespace usertbs2 datafile 'F:oracleproduct10.2.0oradatabooks

' size 30M extent management local uniform size 512k;

SQL> /

createtablespace usertbs2 datafile 'F:oracleproduct10.2.0oradatabooksuser

' size 30M extent management local uniform size 512k;

*

第 1 行出现错误:

ORA-00911: 无效字符

SQL>ed

已写入 file

1* create tablespace usertbs2 datafile 'F:oracleproduct10.2.0oradatabooks

' size 30M extent management local uniform size 512k

SQL> /

表空间已创建。

SQL> alter database datafile 'F:

f' autoextend on next 5M maxsize 100m;

数据库已更改。

SQL> alter tablespace usertbs2 add datafile 'F:oracleproduct10.2.0oradatabo

oksusertbs2_' size 10M;

表空间已更改。

SQL> create temporary tablespacetemptbstempfile 'F:oracleproduct10.2.0orad

' size 20M extent management local autoallocate;

create temporary tablespacetemptbstempfile 'F:oracleproduct10.2.0oradatab

' size 20M extent management local autoallocate

*

第 1 行出现错误:

ORA-25139: CREATE TEMPORARY TABLESPACE 的选项无效

SQL>ed

已写入 file

1* create temporary tablespacetemptbstempfile 'F:oracleproduct10.2.0orad

' size 20M extent management local autoallocate

SQL>ed

已写入 file

1* create temporary tablespacetemptbstempfile 'F:oracleproduct10.2.0orad

' size 20M;

SQL> /

create temporary tablespacetemptbstempfile 'F:oracleproduct10.2.0oradatab

' size 20M;

*

第 1 行出现错误:

ORA-00911: 无效字符

SQL>ed

已写入 file

1* create temporary tablespacetemptbstempfile 'F:oracleproduct10.2.0orad

' size 20M

SQL> /

表空间已创建。

SQL> alter database default temporary tablespacetemptbs;

数据库已更改。

SQL> select tablespace_name,file_name from dba_data_files;

TABLESPACE_NAME

------------------------------

FILE_NAME

--------------------------------------------------------------------------------

USERS

F:

SYSAUX

F:

UNDOTBS1

F:

TABLESPACE_NAME

------------------------------

FILE_NAME

--------------------------------------------------------------------------------

SYSTEM

F:

USERS

F:

EXAMPLE

F:

TABLESPACE_NAME

------------------------------

FILE_NAME

--------------------------------------------------------------------------------

USERS

F:

INDX

F:

USERTBS1

F:

TABLESPACE_NAME

------------------------------

FILE_NAME

--------------------------------------------------------------------------------

USERTBS2

F:

USERTBS2

F:ORACLEPRODUCT10.2.0ORADATABOOKSUSERTBS2_

已选择11行。

SQL> alter tablespace usertbs1 offline;

表空间已更改。

SQL> alter tablespace usertbs1 online;

表空间已更改。

SQL> create undo tablespaceundotbsdatafile 'F:oracleproduct10.2.0oradatab

' size 20M;

表空间已创建。

SQL> drop tablespace usertbs2 including contents and datafile;

droptablespace usertbs2 including contents and datafile

*

第 1 行出现错误:

ORA-00905: 缺失关键字

SQL> drop tablespace usertbs2 including contents and datafiles;

表空间已删除。

SQL> select tablespace_name,file_name from dba_data_files;

TABLESPACE_NAME

------------------------------

FILE_NAME

--------------------------------------------------------------------------------

USERS

F:

SYSAUX

F:

UNDOTBS1

F:

TABLESPACE_NAME

------------------------------

FILE_NAME

--------------------------------------------------------------------------------

SYSTEM

F:

USERS

F:

EXAMPLE

F:

TABLESPACE_NAME

------------------------------

FILE_NAME

--------------------------------------------------------------------------------

USERS

F:

INDX

F:

USERTBS1

F:

TABLESPACE_NAME

------------------------------

FILE_NAME

--------------------------------------------------------------------------------

UNDOTBS

F:

已选择10行。

SQL>