OraFAQ Forum: Server Utilities » How to Know corresponding .dbf file to the related database?

Home » RDBMS Server » Server Utilities » How to Know corresponding .dbf file to the related database?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Know corresponding .dbf file to the related database? [message #72261]

Sun, 27 April 2003 23:34

sachin kumar gupta
Messages: 157
Registered: March 2003

Senior Member

Hi,
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 corresponding .dbf file to the related database? [message #72289 is a reply to message #72261]

Fri, 02 May 2003 03:34

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi,

pls try
select table_name, tablespace_name from dba_tables
where table_name = '<your table_name>';

regards
Uwe

Report message to a moderator

Re: How to Know corresponding .dbf file to the related database? [message #72290 is a reply to message #72261]

Fri, 02 May 2003 03:34

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi,

pls try
select table_name, tablespace_name from dba_tables
where table_name = 'your table_name';

regards
Uwe

Report message to a moderator

Re: How to Know corresponding .dbf file to the related database? [message #72323 is a reply to message #72261]

Fri, 16 May 2003 06:28

BIRENDER KUMAR
Messages: 18
Registered: May 2003

Junior Member

connect as sys.
select * from v_$datafile;
There u will get lot of information regarding ur db.
or u can export database form old one and import it to new.

Report message to a moderator

Previous Topic:	ora-01034 oracle not available
Next Topic:	Help..! Inter Instance IPC Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 08:08:35 CST 2024