SQL> select *from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\SKY\USERS01.DBF
4 USERS 5242880 640 AVAILABLE
4 YES 3.4360E+10 4194302 160 5177344 632
ONLINE

FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\SKY\SYSAUX01.DBF
3 SYSAUX 251658240 30720 AVAILABLE
3 YES 3.4360E+10 4194302 1280 251592704 30712
ONLINE

FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\SKY\UNDOTBS01.DBF
2 UNDOTBS1 26214400 3200 AVAILABLE
2 YES 3.4360E+10 4194302 640 26148864 3192
ONLINE

FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\SKY\SYSTEM01.DBF
1 SYSTEM 503316480 61440 AVAILABLE
1 YES 3.4360E+10 4194302 1280 503250944 61432
SYSTEM

SQL> create tablespace cognos
2 datafile 'C:\oracle\product\10.2.0\oradata\sky\cognos1.dbf' size 300M;
表空间已创建。
SQL> CREATE TEMPORARY tablespace temp_cognos
2 tempfile 'C:\oracle\product\10.2.0\oradata\sky\TEMP_cognos.DBF';
CREATE TEMPORARY tablespace temp_cognos
*
第 1 行出现错误:
ORA-01119: 创建数据库文件
'C:\oracle\product\10.2.0\oradata\sky\TEMP_cognos.DBF' 时出错
ORA-17610: 文件 'C:\oracle\product\10.2.0\oradata\sky\TEMP_cognos.DBF' 不存在,
大小也未指定
ORA-27041: 无法打开文件
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。

SQL> CREATE TEMPORARY tablespace temp_cognos
2 tempfile 'C:\oracle\product\10.2.0\oradata\sky\TEMP_cognos.DBF' size 300m;
表空间已创建。
SQL> create user cognos identified by cognos default tablespace cognos temporary
tablespace temp_cognos;
用户已创建。
SQL> grant dba to cognos;
授权成功。
SQL> grant connect to cognos;
授权成功。
SQL> select * from dba_grant;
select * from dba_grant
*
第 1 行出现错误:
ORA-00942: 表或视图不存在

SQL> quit;
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开
C:\Documents and Settings\Administrator>sqlplus cognos/cognos@sky
SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 2月 3 09:45:24 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select *from tab