to view data in oracle image file...

Posted on 2014-08-12
Last Modified: 2014-08-12
Which of the following is practical:

1. Read the content of this image file from MySQL or SQL Server express?
2. Some other Oracle free product with read-only capability.
3. Buying oracle to view the data in this image file.

Thank you.
Question by:Mike Eghtebas
    LVL 15

    Expert Comment

    Sorry but which image file do you refer to?
    Oracle can read any kind of binary data using BLOB data type. However, most of the times what programmers are doing is saving the path of the image to show on the database and load the image on the client side after retrieving the path stored on the database.

    Hope it helps.
    LVL 33

    Author Comment

    by:Mike Eghtebas
    re:> Sorry but which image file do you refer to?

    Customer states, they will provide image file of the database. This file is to contain all of the data from the database I suppose. This will be a file disconnected from it source, I suppose. I think I need some learning to do. With the interest on the tables and their content, you maybe want to give some brief education.

    Is it possible the customer means a url to their database when they refer to image file?

    LVL 15

    Accepted Solution

    oh, sorry, now I understand you mean the image raw file/s of the database.

    You need exactly the same database engine to use an image raw file, and most of times the same kind of machine and operating system., because you are referring to a physical backup.

    You would need an expert to restore it. It can be easier if you have a logical backup (an SQL script that has all the instructions to create the database with its structures and contents).

    Hope it helps. Regards.
    LVL 33

    Author Closing Comment

    by:Mike Eghtebas
    Thank you,

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    779 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

    11 Experts available now in Live!

    Get 1:1 Help Now