Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

table partition tablespaces

Status
Not open for further replies.
Advocate

Advocate

IS-IT--Management
Joined
Oct 18, 2000
Messages
135
Location
GB
hi guys,

brain dead here because i cannot find the oracle dictionary table/view that will give me the name of the tablespace used by each partition in a partitioned table ... help please ...



regards, david - no such thing as problems - only solutions.
 
Sort by date Sort by votes
colleague just helped ...

dba_extents

substitute table name for segment name seems to work ...

regards, david - no such thing as problems - only solutions.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question Question
Inserting Text Decimal to Table Error
Replies
4
Views
1K
carp
carp
EM1107
  • Locked
  • Question Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
1K
carp
carp
Andrzejek
  • Locked
  • Question Question
Copy a table from Test to Production
Replies
1
Views
366
carp
carp
DeShaun
  • Locked
  • Question Question
Mutiple Where table in Update/Set
Replies
10
Views
603
fredericofonseca
fredericofonseca
harfri
  • Locked
  • Question Question
Insert data from Table A into Table B how can I do that?
Replies
3
Views
509
carp
carp

Part and Inventory Search

Sponsor

Back
Top