Author Topic: adding .dbf files to the existing database?  (Read 3636 times)

AfjalP

  • Newbie
  • *
  • Posts: 1
    • View Profile
adding .dbf files to the existing database?
« on: April 18, 2009, 06:49:01 PM »
Hello all

i recently created database, i have existing datafiles (.dbf) in some other directory, i would like to add all the datafiles to the newly created database, the new database has onle 4 datafiles(users01.dbf, sysaux01.dbf, undotbs01.dbf and system01.dbf);  now i want to add the all the other .dbf files that are located in different directory to the database.

please help me how to add all the .dbf files to the database.

Thanks to all


Mike

  • Administrator
  • Hero Member
  • *****
  • Posts: 1999
    • View Profile
Re: adding .dbf files to the existing database?
« Reply #1 on: April 20, 2009, 07:31:48 AM »
A couple of suggestions:

Try DBF-to-Oracle, a program to migrate DBase/FoxPro/Clipper (*.dbf) databases to Oracle server.
Available at: http://www.convert-in.com/dbf2ora.htm


Try using the Oracle Migration Workbench:
http://www.oracle.com/technology/tech/migration/workbench/index.html


"Ask Tom" also has some tips on how to do this:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:711825134415