Oracle schema creation

[#1]

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

[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