Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Creating a access schema from a oracle 8.0.5 database.
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
--
+------------------------------------------------+Received on Sat Sep 04 1999 - 23:44:19 CDT
| Carl Spangenberger karls_at_ix.netcom.com |
| Linux Guru/Java Programmer |
+------------------------------------------------+
![]() |
![]() |