Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

What tablespace is used?

What tablespace is used?

What tablespace is used?

Good day (or night) to all.

So here's the scenario:

User X defaults to tablespace TBS_A. There are other objects in tablespace TBS_B that user X are able to do stuffs with (update, insert, query, etc.). My question is - what tablespace is used when user X do say, an update on MyTable1 in TBS_B tablespace? Will user X still use TBS_A which is its default or use TBS_B because that's where the object is being accessed?


kilroy knight

"Once a king, always a king. But being a knight is more than enough."

RE: What tablespace is used?

Unless the query the user is doing requires a TEMP space usage, neither of the tablespaces mentioned above will be used by the user itself.

and yes I know this is not the answer you were expecting (although it is correct), but this does look like a homework question.


Frederico Fonseca
SysSoft Integrated Ltd

FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?

RE: What tablespace is used?

Thank you for taking time to reply, good sir.

But no, this is not a homework question. Our company is using Oracle 10g with several schemas and users. These users can query on tables residing in various tablespaces. There is this one particular tablespace that grows unusually fast. Users query several tables in this tablepsace very often but the users are assigned with their own tablespace. Thus, my original question. And yes, they have also a separate temp space.

kilroy knight

"Once a king, always a king. But being a knight is more than enough."

RE: What tablespace is used?

It doesn't matter what tablespace a table is in, it only matters if you have been granted the rights to view the table.

Lead Application Developer
New York State, USA

RE: What tablespace is used?

Tables live in tablespaces. If you do something that requires more space, like an insert or an update, the space will be allocated within the table's tablespace. Simply querying a table won't make any demands on tablespaces, other than possibly a temp tablespace as pointed out above.

A user's default tablespace only comes into play if they create an object - a table, index, etc. - without explicitly specifying a tablespace. If they do that, the object gets created in their default tablespace.

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd

RE: What tablespace is used?

Thank you, Bill and Chris, for taking the time to reply. And for an extra effort in explaining more, here's a star for you Chris. I appreciate it.

kilroy knight

"Once a king, always a king. But being a knight is more than enough."

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close