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 gkittelson 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
Jul 12, 2002
32
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

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
673
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
730
SkipVought
S
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
815
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
317
Livia8
Livia8
Andrzejek
  • Locked
  • Question
Modify columns - parts of virtual column 2
Replies
8
Views
1K
carp
carp

Part and Inventory Search

Sponsor

Back
Top