Home » RDBMS Server » Server Administration » question
question [message #52797] Wed, 14 August 2002 08:23 Go to next message
Prasad
Messages: 104
Registered: October 2000
Senior Member
i am creating on tablesapce it is having two datafiles....i created one table on that tablespace ...but how i can find out in which datafile the table is stored.....

Report message to a moderator

Re: question [message #52800 is a reply to message #52797] Wed, 14 August 2002 16:14 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Run this query:

SELECT table_name,
tablespace_name
FROM dba_tables
WHERE table_name LIKE 'put_your_table_name_here';

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Re: question [message #52944 is a reply to message #52797] Wed, 21 August 2002 06:03 Go to previous message
Suresh
Messages: 189
Registered: December 1998
Senior Member
I think you can't findout which datafile. You will only know which tablespace.

Report message to a moderator

Previous Topic: Trigger Err (Insert into another DB)
Next Topic: recreate tablespace from .ORA file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 13:33:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.