Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    16

    Unanswered: copy oracle to mdb

    Is it possible to grab a copy of a oracle db and save it as a mdb? something even similar to a mysqldump. if so, what is the best way to do this, without stopping and re-starting oracle?

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    I doubt if you can get the whole db, what would be done with the triggers/stored procs etc which aren't supported?

    You can import individual tables though. Set up an ODBC DSN to your Oracle DB, Open MS Access and use File->Get External Data. On the file open dialog, choose "Files of Type ... ODBC Datasources" and follow the prompts.

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    On the surface your question is somewhat nonsensical.
    Oracle supports many more object types & constructs than MYSQL.
    What do you propose be done with these objects which may be vital to an application continuing to function?

    For real simle data transfer write a small PERL program to read Oracle tables & write into MYSQL.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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