SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how do I check the .dbf file size

763572Jun 1 2010 — edited Jun 1 2010

Hi All,

I want to check which .dbf file is associated with current workspace and also want to check the size of .dbf file.

Here is what i am trying to work on

I have DB with BLOB where lot of records get stored so .dbf file gets filled very quickly. So i am trying to use BFILE instead of BLOB . As far as i understand BFILE will create link to external file and it will not store the file into DB(.dbf file). whereas BLOB will store the data into DB.

So after a complete run with BFILE it should not fill out my .dbf file which was the case with BLOB.

Thanks for the help :)

Edited by: user8959307 on May 31, 2010 10:29 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2010

Added on Jun 1 2010

#pl-sql

3 comments

6,699 views