Message-Id: <24715.322460@fatcity.com> From: Jacques Kilchoer Date: Wed, 19 Mar 2003 17:20:53 -0800 Subject: RE: backup the tablespace This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C2EE7E.F36FB6F0 Content-Type: text/plain 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:liujd@cti.ac.cn] > > 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 . ------_=_NextPart_001_01C2EE7E.F36FB6F0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: backup the tablespace

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=3DY" and "imp help=3DY" for a = list of parameters.

example:
on source machine
export ORACLE_SID=3DFROMDB
exp userid=3Dsystem tables=3D(JRK.MGR, JRK.SAL) = file=3Dtables.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=3DTO_DB
imp userid=3Dsystem fromuser=3Djrk touser=3Djrk = tables=3D(MGR, SAL) file=3Dtables.dmp


> -----Original Message-----
> From: liujd [mailto:liujd@cti.ac.cn]
>
> 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 =