Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Database Schema Copying in oracle10G

Ramana.Sv
Frequent Advisor

Database Schema Copying in oracle10G

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.
4 REPLIES
Oviwan
Honored Contributor

Re: Database Schema Copying in oracle10G

Hey

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

Regards
Ramana.Sv
Frequent Advisor

Re: Database Schema Copying in oracle10G

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

like commands please
Yogeeraj_1
Honored Contributor

Re: Database Schema Copying in oracle10G

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

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Mike Reaser
Advisor

Re: Database Schema Copying in oracle10G

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.