Schema Export/Copy

[Former Member]

Hi,

How can we export a schema. We have an mcod system and we want to copy just 1 schema to another server.

thanks

krbas

[Former Member · Accepted solution]

Hi

Can you please tell which schema you wanna export/copy, whether it is a ABAP or JAVA Schema??

You can according decide which tablespaces are related to that particular schema and then perform export or copy whatever you wish.

Regards

Sumit

[Former Member · Accepted solution]

Hi,

Our mcod system have the following instances

(a) DEV - development

(b) SBX - sandbox

we only want to export/copy the DEV instance. We are on ecc5 ABAP system. and oracle 9.2.0.6.

thanks,

krbas

[Former Member · Accepted solution]

Hi,

You can use SAPInst to export the DEV instance

Regards

Umesh K

[andreas_herzog · Accepted solution]

you <b>will be asked during export procedure (using sapinst) which database schema</b> you wish to export...

GreetZ, AH

[Former Member]

when you want to limit on database related tools it is also possible to do a exp/imp using transportable tablespaces.

That is exporting the data dictionary definitions and copy the datafiles.

regards

Peter

[Former Member]

thanks all.

[Former Member]

Hi,

exp test/vinod FILE=test.dmp OWNER=<schemaname> GRANTS=y ROWS=y COMPRESS=y

Or Have a look on http://help.sap.com/saphelp_erp2005vp/helpdata/en/58/6bec38c9fa7e44b7f2163905863575/frameset.htm.

Segment Management with BR*Tools section fro MCOD

Regards

vinod

[Former Member]

Hi,

Note that the use of "exp/imp" for system copies is not fully supported by SAP.