Use Oracle's export and import utility to create a dump file. Export from the source database and import into the target database.
Go to the command prompt on the database server and type in "exp help=Y" and "imp help=Y" for a list of parameters.
example:
on source machine
export ORACLE_SID=FROMDB
exp userid=system tables=(JRK.MGR, JRK.SAL) file=tables.dmp
use binary FTP to copy tables.dmp from database server A to database server B (if the databases are on different hosts)
on target machine
export ORACLE_SID=TO_DB
imp userid=system fromuser=jrk touser=jrk tables=(MGR, SAL) file=tables.dmp
> -----Original Message-----
> From: liujd [mailto:[EMAIL PROTECTED]]
>
> I'm sorry post the text here .but I'm very urgent.
> I created some tablespace and table in it .now I want to copy these to
> another
> Oracle system (the version are same).How to do .
