KNOW MY TABLESPACE [message #187030] |
Thu, 10 August 2006 10:28 |
superoscarin@hotmail.com
Messages: 101 Registered: July 2006 Location: Mexico
|
Senior Member |
|
|
Hi:
I'm a simple user, how can i know what tablespace i'm accessing??
and how can i change it??
Are there any way to specify in a control file (sql loader) the tablespace where my tables are if they´re in another tablespace?
Thanks a lot
Alex.
[Updated on: Thu, 10 August 2006 10:30] Report message to a moderator
|
|
|
Re: KNOW MY TABLESPACE [message #187033 is a reply to message #187030] |
Thu, 10 August 2006 10:36 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>>I'm a simple user, how can i know what tablespace i'm accessing??
Look into user_users.
This shows only the default tablespace. Not all the tablespaces you have quota on.
test@9i > desc user_users
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
USERNAME NOT NULL VARCHAR2(30)
USER_ID NOT NULL NUMBER
ACCOUNT_STATUS NOT NULL VARCHAR2(32)
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30)
CREATED NOT NULL DATE
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)
EXTERNAL_NAME VARCHAR2(4000)
>>how can i change it?
You can create any object in any tablespace you allowed to.
RESOURCE role allows you to write to any tablespace.
>>Are there any way to specify in a control file (sql loader) the tablespace where my tables are if they´re in another tablespace?
IN sql*loader, you no need to worry about it.
Wherever the table is , you will loading data into it.
If you want to have the data to be loaded into different tablespace, move the table.(if it is a partitioned table, it is a different case)
[Updated on: Thu, 10 August 2006 10:37] Report message to a moderator
|
|
|
|
|
|