Hi all,
Can anybody tell me how can i copy a sql table (including its
structure and data) which is in one system to the other system in
oracle9i. Thank you..

On Sep 8, 10:32 pm, Nuthan <newnut... (AT) gmail (DOT) com> wrote:
Please explain what you mean by "the other system".

If you mean to another computer you are basically going to use the
export (exp) and import (imp) commands. This link may help.
http://www.oracle.com/pls/db102/rank...&partno=b14215

If you actually mean to another table within a schema or another table
in another schema then look up the CREATE TABLE command and notice the
CREATE TABLE <name> AS SELECT ... option.

And you really might consider reading the Concepts manual
http://download.oracle.com/docs/cd/B...b14220/toc.htm

Also note there are four Oracle specific groups. You particular
question is about tools related to oracle and so could have gone in
the
comp.databases.oracle.tools
newsgroup.

HTH,
ed

SQL Script Builder is software that create a database sql script (or dump
file) from any ODBC data source. The script produced will migrate the
database (multiple tables selection) or only one table and the records.
Scripts are available in 5 output formats ; MySql, MS SQL, Oracle, Pervasive
and PostgreSQL. SQL Script Builder is very simple to use, you just have to
choose the database and the table from the list. SQL Script Builder scripts
can be used on your DBMS (database management system) or uploaded on a
server.

SQL Script Builder can be used for example for database migration from your
Access database to MySql database, or MySql database to MS SQL database and
vice versa. You don't have to transfer all database, you can if you wish
only import one table at a time. There's no limits, all you need is the ODBC
driver for the database you wish to import from. ODBC is a universal
interface, almost every database provider support it.

Software URL : http://www.sqlscriptbuilder.com

Download URL :
http://www.sqlscriptbuilder.com/down...ildersetup.exe

"Nuthan" <newnuthan (AT) gmail (DOT) com> a écrit dans le message de news:
1189305159.482339.219560 (AT) r34g20...oglegroups.com...

SQL Script Builder is software that create a database sql script (or
dump file) from any ODBC data source. The script produced will migrate
the database (multiple tables selection) or only one table and the
records. Scripts are available in 5 output formats ; MySql, MS SQL,
Oracle, Pervasive and PostgreSQL. SQL Script Builder is very simple to
use, you just have to choose the database and the table from the list.
SQL Script Builder scripts can be used on your DBMS (database
management system) or uploaded on a server.

SQL Script Builder can be used for example for database migration from
your Access database to MySql database, or MySql database to MS SQL
database and vice versa. You don't have to transfer all database, you
can if you wish only import one table at a time. There's no limits,
all you need is the ODBC driver for the database you wish to import
from. ODBC is a universal interface, almost every database provider
support it.

Software URL : http://www.sqlscriptbuilder.com

Download URL : http://www.sqlscriptbuilder.com/down...ildersetup.exe



On 8 sep, 22:32, Nuthan <newnut... (AT) gmail (DOT) com> wrote:

On Sep 8, 10:32 pm, Nuthan <newnut... (AT) gmail (DOT) com> wrote:
My post seems to have been lost.

You should look up the exp (export) and imp (import) commands.

It is not necessarily clear what you mean by system. Do you mean
another schema? another Oracle instance? a totally different computer?
anyway exp/imp will work. If you were merely going to another schema
and you have select privilege on the source table, then the
CREATE TABLE <newname> AS SELECT ...
command will work.

It's all in the manuals.
Ed