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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find tables and columns with LOBs

Status
Not open for further replies.
Phil99

Phil99

Programmer
Joined
Jul 12, 2002
Messages
32
Location
GB
Hi,

I'm looking for a script to find all tables, columns in a tablespace which use lobs and details of the lob settings, such as In Row etc.

Thanks

Phil
 
Sort by date Sort by votes
The view SYS.DBA_LOBS probably has most of what you want.

Retired (not by choice) Oracle contractor.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question Question
Oracle iCare Gift & Loyalty Portlet - Setup and configurations.
Replies
0
Views
300
jandresHDS
J
TheLazyPig
  • Locked
  • Question Question
Merge Into with multiple execution
Replies
1
Views
1K
carp
carp
sqlPower
  • Locked
  • Question Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
1K
SkipVought
S
Andrzejek
  • Locked
  • Question Question
Get part of a string with SQL
Replies
2
Views
1K
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC
Replies
5
Views
786
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top