Results 1 to 6 of 6

Thread: GET DATA FROM .DBF FILE, ORACLE 9i

  1. #1
    Join Date
    Apr 2008
    Posts
    3

    GET DATA FROM .DBF FILE, ORACLE 9i

    Hi all..
    Just to the point.

    Case:
    I take all *.dbf file from oracle 9i installed in Solaris 9.2 system.

    I want to read the content/data from those .dbf files on my PC (Windows XP).

    Question:
    1. Is it possible to read the data from those .dbf file without installing oracle in my PC?

    2. Is there any tool to do it?

    3. If it is not possible, is there another way that should I do to get the data?

    Any comment, answer, recommendation will greatly appreciated. Thanks a lot.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    It may be possible but you will not get properly formatted data looking into data file directly.

    Best way is to export data from solaris and import into windows oracle installation.

  3. #3
    Join Date
    Apr 2008
    Posts
    3

    Get data from .dbf file, oracle 9i

    Quote Originally Posted by skhanal
    It may be possible but you will not get properly formatted data looking into data file directly.

    Best way is to export data from solaris and import into windows oracle installation.
    Could you please gave the step by step to export data from solaris and import into windows oracle installation.

    Thanks a lot skhanal

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You need to run exp command to export and imp command to import into existing database.

    Run exp -help to get the proper syntax.

  5. #5
    Join Date
    Apr 2008
    Posts
    1

    sabri

    hi !!!
    I want download oracle .
    thank you
    Last edited by sabri; 04-21-2008 at 04:22 PM.

  6. #6
    Join Date
    May 2008
    Posts
    1

    Smile

    The DBF does't mean that this is Dbase file.
    It can be any extension.
    And encripted by Oracle

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •