Oracle schema creation

[BAJAJ-DXC]

Hello,

Requirment: We need to setup portal development with the Oracle instance pointing to portal PRD.

I had one Development oracle Database and one production oracle database but Development database license is no longer valid.

So, I want to create a separate schema in Production and point that new schema to store application tables related to Development then will scratch the Development database.

There will be one Database for production and Development but schema's will be different later on.

Regards,

Vasu

[BAJAJ-DXC]

Still i didnt get the answer

[Former Member]

hi,

have you tried the oracle export and import method.

[BAJAJ-DXC]

If i do export/import then i will find my data in production but i want to point my development database to production

[lbreddemann]

>

> Still i didnt get the answer

So what?

Maybe people here do have other things to do as well?

What was your effort of research in this topic up to now?

Anyhow, think about it: you changed the schemaname for the development database.

So to "point" your development system to it, you will need to change the references to the database schema there.

This includes the logon data to the database and maybe environment settings like dbs/ora/schema.

In general the idead to put development and production systems into one instance is a very bad one.

What if your developers run a query that consumes all resources of the DB or even crashes it?

What if you want to try out the next database patch on the development system first?

By merging the two instances you loose the advantage of a multi-system-landscape.

regards,

Lars

[Former Member]

HI,

use this command to import to the particular schema and to user which you have created:

imp file=(complete path) fromuser=schema_user_name touser=dev_schema_user_name log=c:\logfile name

b4 executing shut off all your sap services and instance. after executing in the sqlplus, (by login as dev_schema_user_name or sysdba as DBA) if u get any error send the log file from the given path and file name.

reg:

Ahmed S

=========

[lbreddemann]

ah - before I forget...

I assume you are aware that exp/imp is not supported for a sytemcopy like this with SAP.

To move the schema you should use the R3Load instead.

regards,

Lars

[Former Member]

thanx lars for correcting.

reg:

Ahmed

[Former Member]

hi,

to create a schema in the oracle database u need to go to the sqlplus in the command prompt.,

and login as the database administrator. and execute this command with your schema name

=================

create user USER_NAME identified by SCHEMA_NAME

GRANT CONNECT,RESOURCE TO User_name IDENTIFIED BY schema_name;

=================

Create tablespace if required.., then u can assign.

Reg,

Ahmed

[BAJAJ-DXC]

Hello Ahmed,

Thanks for your promt reply. I created the user/tablespace already.

but, How to point that newly created schema to Development changes?

Regards,

Vasu