Re: exp/imp simple question...

hi louis,

well suppose you wanna take user X from server S1 to S2. now the easiest way to migrate would be exporting user X from S1 and importing it in S2. The actual IMP/EXP commands could be differet depending on the version of your Oracle server, so we suppose IMP and EXP being the server specific commands for importing and exproting respctively. With these assupmtions let's see how would you do it.

1. export the user X from S1 by:

  EXP X/passwordforX_at_connectStringForS1 owner=X file=XFromS1.DMP

please note you could also authenticate yourself by any dba's account as well.

2) create user X on S2 with some default tablespace, the tablespace name doesn't has to be the same as it was on S1 for user X

3) improt on the dump file in S2
  IMP X/passwordForXAtS2_at_connectStringforS2 file=XFromS1.DMP full=y

and bang, you've completed the exodus! by the way i assumed both of your servers are of same version. or at least S2 is not a lower version server than S1.

for further gory details of IMP/EXP please refer to Oracle online manual. so happy readings and have a nice one.

hope this helps.

:) ATTA In article <8sfkds$v4i$1_at_nnrp1.deja.com>,   louis.audet_at_ssss.gouv.qc.ca wrote:
> Hi,
>
> I'd like to migrate a schema from a server to another server. Suppose
> that i recreate the tablespace and teht user on the second server,
 what
> is the simplest way to accomplish it ?
>
> Thanks,
>
> Louis Audet
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--

getting the meanin' of data...


Sent via Deja.com http://www.deja.com/
Before you buy.