need help in configuring oracle db to use bfile modus

Posted on 2011-10-27
Last Modified: 2012-05-12
Hi experts, I need helping with to configure an oracle 10G database to use bfiles.
The application which uses this db is using blob now and the company which made this application wrote a convert script to put all the blob files on disk.
I have to configure  the db to use bfiles instead of blob. I know I have to create physical directories on disk where the files will be exported to.
I read that I have to create logical directories as sys and grant permission to those directories to the application user.
I want to know if I have it right.
I created /u2/alm/finance and /u2/alm/photo and also a few more...
I will have to do the following as sys.
sqlplus>create directory alm_data as '/u2/alm/photo';
then I will have to grant permission to the user of the directory.
sqlplus>grant read,write on directory data to alm_admin;
now comes the point that I don't understand. a table has to be created to store pointer for large objects. I asume that this is also a sys table, what is the info that has to be stored there and how is this info used by the package. I see that through the aplication update views are being created which has the descriptions of the bfiles and also an id. a few procedures are being created also by the application, one to turn on named directory, and to turn on directory on id. But the connection between all these is not clear to me. I would like for someone who has done this bfile thing before to give me a brief explantion, like to a 2 year old, so that I can see the link between all the compnents that has to exist so that the bfile modus can be successfull.
Question by:sharscho
    LVL 76

    Accepted Solution

    Don't know about a 'sys' table.  Any regular table should work.

    Have you been through the docs on this?

    Check out the link below.  It has an insert example.

    Author Closing Comment

    Did not help much but I found the solution myself...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now