RATE THIS ANSWER
+2
Click to Vote:
- 2
0
Last Answered:
Jul 16 2008 5:49 PM GMT
by Jcmdba 
425 pts.
There are a number of ways to "export" the table definitions from Oracle. It depends on your desired use. Oracle has an export utility which you can use to export. On a UNIX system, the command is "exp". There are various options to export just definitions (schema) or both schema and data. The generated file is only usable or "importable" into other Oracle databases, so it has limited value. If you choose this route, be sure to remember that the file is binary and if you transfer or "ftp" the file be sure to select binary mode.
You also could use a number of other facilities to generate files with the table descriptions or to generate table create statements which could be used to create those structures in another SQL based database system.
I suggest working with your Oracle DBA to identify the method and utilities which will best meet your needs.
Application deployment, Database programming, VB, Oracle 8i
I am developing an application with VB 6 as front end and Oracle 8i as back end. I need to run my application in other systems also, so I need to export the table structures of my application to other systems. How can I do this? Thank you. 
