Database Schema Copying in oracle10G

[Ramana.Sv]

Hi,
i have 2 database Servers(HP-UX with oracle10G)ex:(1) 10.1.0.1 and (2)1.0.0.2 like this, i want copy the one shema from 10.1.0.1 to 1.0
.0.1 how to do this one pls help me sir...


Thank you.

[Oviwan]

Hey

export the schema with datapump (expdp) and import it in the other database with impdp

Regards

[Ramana.Sv]

please some more information BUZ iam new to this one pls sir...

like commands please

[Yogeeraj_1]

hi,

You can also use exp followed by imp.

exp help=yes
or
imp help=yes

to get the syntax information.

e.g.
Example: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)
or TABLES=(T1:P1,T1:P2), if T1 is partitioned table

If you want further help, please post more details.

This is supposed to be quite straight forward.

kind regards
yogeeraj

[Mike Reaser]

Did you just obtain a copy of a system set up for use by a customer of Southeastern Data Cooperative http://www.sedata.com ?

This question, along with your question in http://forums.itrc.hp.com/service/forums/questionanswer.do?threadId=1165276 that you posted, makes it seem like you're trying to reverse-engineer the intellectual property of a small American company.