RE: backup the tablespace

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 19 Mar 2003 17:20:53 -0800
Message-Id: <24715.322460@fatcity.com>

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_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.45">
<TITLE>RE: backup the tablespace</TITLE>
</HEAD>
<BODY>

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 [<A =
HREF=3D"mailto:liujd_at_cti.ac.cn">mailto:liujd_at_cti.ac.cn</A>]
 > 
 > 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 =
Received on Wed Mar 19 2003 - 19:20:53 CST