<div>
Hi By mistake I mentioned, 9i to 10g upgrade, please read 10g as Dest database and 9i as source database, the entire answer solves your problem
</div>


Hi By mistake I mentioned, 9i to 10g upgrade, please read 10g as Dest database and 9i as source database, the entire answer solves your problem

<div>
<div class="content wysiwyg-content">
I have a working database (Oracle 10g) that has about 70 tables that I want to move to a diffrent server. &nbsp; Is there a way to generate .SQL script that contains all the CREATE TABLE syntax for each table from an existing database. &nbsp;Or is there a better method to move all the tables from the old server to the new server?<br />
<br />
Thank you
</div>
</div>


I have a working database (Oracle 10g) that has about 70 tables that I want to move to a diffrent server.   Is there a way to generate .SQL script that contains all the CREATE TABLE syntax for each table from an existing database.  Or is there a better method to move all the tables from the old server to the new server?

Thank you

Moving tables from one server to another

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.