OraFAQ Forum: Server Administration » view what is stored in a datafile

Home » RDBMS Server » Server Administration » view what is stored in a datafile

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

view what is stored in a datafile [message #153113]

Thu, 29 December 2005 03:41

raddisonlee
Messages: 29
Registered: March 2005

Junior Member

hi all ,
how to view the content of datafile file , if a user tablespace
with two datafiles , what is stored in each one .can i ?

Report message to a moderator

Re: view what is stored in a datafile [message #153116 is a reply to message #153113]

Thu, 29 December 2005 04:39

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Choose the FILE_ID of the file attached with the tablespace from DBA_DATA_FILES view.

then

select distinct segment_name from dba_extents
where file_id = YOUR_FILE_ID;

Report message to a moderator

Re: view what is stored in a datafile [message #153136 is a reply to message #153116]

Thu, 29 December 2005 06:54

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

oracle datafile and its contents are proprietory to oracle.
So you cannot acitvely see the contents ( like a text file).
Understand something about the Physical and Logical architecture.
Physically, oracle stores the data in datafiles.
Logically, the are grouped into extents/segments.
You can only get those information by querying dba_extents or whatever.

Report message to a moderator

Previous Topic:	space allocated to user
Next Topic:	scripts for creating Instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 13:19:16 CST 2025