Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Creating a access schema from a oracle 8.0.5 database.

Creating a access schema from a oracle 8.0.5 database.

From: Carl Spangenberger <karls_at_ix.netcom.com>
Date: Sun, 05 Sep 1999 00:44:19 -0400
Message-ID: <37D1F523.9BD97C67@ix.netcom.com>


I need to take a oracle schema (table definitions, data) from a oracle 8.0.5 database to a Access Database.
Is there a utility to export the table definitions to a file. I have looked and can not find one. Do not
what too write a perl program to query the Data Dictionary and generate the table. I also need to export
the table data into a comma delimited file so I can import it into a Access database.

I need to replicate data from an oracle database on a Sun to window 95 machines on portables.
It would be a lot easier to use oracle lite on the portables, but that is not an option.

Any help would be greatly appreciated.

Carl Spangenberger

--

+------------------------------------------------+

| Carl Spangenberger karls_at_ix.netcom.com |
| Linux Guru/Java Programmer |
+------------------------------------------------+
Received on Sat Sep 04 1999 - 23:44:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US