-
Dear Friends
I am having 10 Datafiles and these datafiles are attached with 3 Tablespace, 7 in the Main Tablespace and others are with Index tablespace.
Whenever I am seeing the space of the datafile in the DBA_DATA_FILES, it is showing all 10 datafiles, But whenever i am seeing Used Space of each datafile through the DBA_FREE_SPACE, then status of 2 Datafiles are not coming in the DBA_FREE_SPACE, Only Query show the 8 datafiles.
Can anyone tell me, How I can see the space of these 2 files and why it is not showing in the DBA_FREE_SPACE table.
Thanks in advance.
Sandeep
-
What is the status of the files in DBA_DATA_FILES?
Is it possible that the two that are not showing in DBA_FREE_SPACE have a different status? Just a guess.
Good luck.
David Knight
OCP DBA 8i, 9i, 10g
-
Dear Sir,
Status for all datafiles are AVAILABLE in DBA_DATA_FILES.
Thanks
Sandeep
-
Sorry about that.
What is the status of the files in V$DATAFILE? Could 2 of them be OFFLINE?
David Knight
OCP DBA 8i, 9i, 10g
-
those two files might be 100% full and then they won't show up in dba_free_space
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|