dev_dba
asked on
default
When we create a table what is the default user ... if we do not specify.
same way what will be the default tablespace..
same way what will be the default tablespace..
If you don't specify an owner, the table is owned by who ever who are connected to the database as.
Type "show user" to see who you are connected as (if in sqlplus).
Each user has a default tablespace assigned when the user is created. If no tablespace is specified in the create table statement, that tablespace is used.
select default_tablespace from dba_users where username = 'YOUR_OWNER_NAME';
Type "show user" to see who you are connected as (if in sqlplus).
Each user has a default tablespace assigned when the user is created. If no tablespace is specified in the create table statement, that tablespace is used.
select default_tablespace from dba_users where username = 'YOUR_OWNER_NAME';
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Further to my above, if not using sqlplus (TOAD or some other tool) you can also do this to see your connected username:
SELECT sys_context('USERENV', 'SESSION_USER') FROM DUAL;
SELECT sys_context('USERENV', 'SESSION_USER') FROM DUAL;
ASKER
Thank you..
select default_tablespace from dba_users
where username='SCOTT'