OraFAQ Forum: General » reg schemas

Home » Other » General » reg schemas

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

reg schemas [message #126301]

Sun, 03 July 2005 02:45

shankar.mf
Messages: 12
Registered: May 2005
Location: chennai

Junior Member

hi folks!

i have a doubt reg schemas.

when we install oracle then a schema will be created automatically right, now wt i want to do is like i want to work on oracle as well as in forms 6i and i wish to work in two different schemas beco'z the table list is becoming too much if i work in one schema. so plz help me hw do create another schema and to work with separate schemas in oracle and forms 6i.

awaiting for ur reply,

thanks in advance

bye
cheers

Report message to a moderator

Re: reg schemas [message #126304 is a reply to message #126301]

Sun, 03 July 2005 02:59

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

You can create additional schemas with the "CREATE USER ..." command. Look it up in the SQL Reference Guide. Here is a quick example:

SQL> CREATE USER test1 IDENTIFIED BY pass
  2  DEFAULT TABLESPACE users
  3  TEMPORARY TABLESPACE temp
  4  QUOTA UNLIMITED ON users
  5  /

User created.

SQL>
SQL> GRANT connect, resource TO test1;

Grant succeeded.

SQL>
SQL> CONNECT test1/pass
Connected.
SQL>
SQL> SELECT sys_context('USERENV', 'CURRENT_SCHEMA') FROM dual;

SYS_CONTEXT('USERENV','CURRENT_SCHEMA')
--------------------------------------------------------------------------------
TEST1

Best regards.

Frank

Report message to a moderator

Re: reg schemas [message #126318 is a reply to message #126304]

Sun, 03 July 2005 05:47

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

adding to Frank's explanation:

You can Open SQL*Plus for as many users as you want depending on the memory of your computer.
You can also use TOAD to work on more than one schema.
You can also open more than one session of Forms Builder and can work on diffrent schemas.

Regards.

Report message to a moderator

Previous Topic:	reg oracle9i/forms6i connectivity
Next Topic:	D2K interview Question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 24 10:16:47 CDT 2026