<div>
Anil,<br />
The first option given by tsachi is a better one. Just to add to it, you need to create a database link for origDB before executing the above query.<br />
<br />
cheers,<br />
Deva.
</div>


Anil,
The first option given by tsachi is a better one. Just to add to it, you need to create a database link for origDB before executing the above query.

cheers,
Deva.

<div>
Or go here to generate a script to recreate a table: <br />
<a href="http://www.orafaq.com/scripts/sql/cre8copy.txt" rel="ugc">http://www.orafaq.com/scripts/sql/cre8copy.txt</a><br />
<br />
Or<br />
<br />
<a href="http://www.orafaq.com/scripts/sql/mktable.txt" rel="ugc">http://www.orafaq.com/scripts/sql/mktable.txt</a><br />
<br />
Cheers!<br />
Mark
</div>


Or go here to generate a script to recreate a table:
http://www.orafaq.com/scripts/sql/cre8copy.txt [http://www.orafaq.com/scripts/sql/cre8copy.txt]

Or

http://www.orafaq.com/scripts/sql/mktable.txt [http://www.orafaq.com/scripts/sql/mktable.txt]

Cheers!
Mark

<div>
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
<br />
Accept tsachi's comment as answer..<br />
<br />
Please leave any comments here within the next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!<br />
<br />
Henka<br />
EE Cleanup Volunteer 
</div>


No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept tsachi's comment as answer..

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
What is the syntax to copy a table attribute values from one database to different table in different database. Note that the table names may not be same.<br />

</div>
</div>


What is the syntax to copy a table attribute values from one database to different table in different database. Note that the table names may not be same.


copying table attribute values from one database to different table in different database

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.