sf49er.bikle.com 8 % sqi

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 7 18:19:42 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

18:19:42 SQL> @qrydbf
18:19:52 SQL> set echo on
18:19:52 SQL> 
18:19:52 SQL> rem
18:19:52 SQL> rem dbf.sql
18:19:52 SQL> rem
18:19:52 SQL> 
18:19:52 SQL> rem @(#) Queries description of datafiles
18:19:52 SQL> 
18:19:52 SQL> COLUMN MBYTES FORMAT 999,999
18:19:52 SQL> 
18:19:52 SQL> SELECT
18:19:52   2  SUBSTR(TABLESPACE_NAME, 1, 16) TABLESPACE_NAME
18:19:52   3  ,SUBSTR(FILE_NAME, 1, 51) FILE_NAME
18:19:52   4  ,FILE_ID ,BYTES/1024/1024 MBYTES
18:19:52   5  FROM DBA_DATA_FILES
18:19:52   6  ORDER BY TABLESPACE_NAME, FILE_NAME
18:19:52   7  /

TABLESPACE_NAME
------------------------------
FILE_NAME
------------------------------------------------------------------------------------------------------------------------
   FILE_ID   MBYTES
---------- --------
GENDATA
/u2/oracle/data/ABIKLE/ABIKLE_gendata_01.dbf
	 5	700

RBS
/u2/oracle/data/ABIKLE/ABIKLE_rbs_01.dbf
	 2    2,000

SYSTEM
/u2/oracle/data/ABIKLE/system01.dbf
	 1	500

TOOLS
/u2/oracle/data/ABIKLE/ABIKLE_tools_01.dbf
	 3	200

USERS
/u2/oracle/data/ABIKLE/ABIKLE_users_01.dbf
	 4	100


18:19:52 SQL> 
18:19:52 SQL> EXIT
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
sf49er.bikle.com 9 %