Home » RDBMS Server » Server Administration » How to know the corresponding .dbf file to my database?
How to know the corresponding .dbf file to my database? [message #56810] Sun, 27 April 2003 23:36 Go to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
I have one big database which is used from so long long ago. The Oracle was installed on my UNIX server by some another person. Now when i am importing the tables into my database, it is showing insufficient table space.
Can anyone suggest how to know the corresponding .dbf file to my database?? So that I can increase the tablespace in that .dbf file.

Sachin Kumar Gupta

Report message to a moderator

Re: How to know the corresponding .dbf file to my database? [message #56815 is a reply to message #56810] Mon, 28 April 2003 01:51 Go to previous messageGo to next message
Deepa
Messages: 269
Registered: November 2000
Senior Member
hi u can query the dba_data_files to know the datafile locations.

Report message to a moderator

Re: How to know the corresponding .dbf file to my database? [message #56822 is a reply to message #56810] Mon, 28 April 2003 23:48 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Run this query and you see the list of datafiles and their location:

SQL> select name from v$datafile;

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Help me please for easy question
Next Topic: need help starting LogMiner utility
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:47:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.