Doubts about tablespace / schema.

[clowbr15]

Personal,

I am new with Oracle and I have this doubt:
I have a TBSPACE TB_01 and I am wanting to create a schema in to create tables in this specific group. I just do not know how to reference my schema with the tablespace I just created.


Thanks to all!

[dr_gori]

Forum DBA

[elidias7]

Good Morning.

For this type of procedure, you must create the user informing the default tablespace that the same will store your objects


This is a simple example for the creation of the user, where you have Name and Password, change to what you want to create
Hugs,

[Tinho]

Only as information to those who are seeking to clarify doubts related to this subject, it follows:

When the DBA creates a new user, Oracle, simultaneously, Creates a schema (of the same name) for this user.

Source: http://www.ebah.com.br/content/ABAAAA89 ... -no-oracle

Att.,