Re: Resizing DataFiles in Personal Oracle 8.0

Query the data dictionary view dba_data_files

SQL> select file_name,tablespace_name from dba_data_files

FILE_NAME                                                    TABLESPACE_NAME
--------------------------------------------- -------------------
C:\ORAWIN95\DATABASE\usr1orcl.ora             USER_DATA
C:\ORAWIN95\DATABASE\rbs1orcl.ora             ROLLBACK_DATA
C:\ORAWIN95\DATABASE\tmp1orcl.ora             TEMPORARY_DATA
C:\ORAWIN95\DATABASE\sys1orcl.ora             SYSTEM

lpacania9954_at_my-dejanews.com wrote in message <7es5ff$1i7$1_at_nnrp1.dejanews.com>...
>Hi,
>
>I'm trying to increase my datafile space in Personal Oracle 8.0 (PO8),
running
>on NT.
>
>But I can't find the .DBF files.
>
>Does anyone know if PO8 uses .DBF files? I've already scanned my drives
for
>.DBF extensions.
>
>Thanks for any help...
>
>-lpacania
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Apr 13 1999 - 06:25:17 CEST