DBA

Monday, December 10, 2018

Select object tablespace


select * from dba_segments
where owner = 'FCCHOST'
and lower(segment_name) like '%fc_%'

Posted by CAM-DBA at 5:56 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

CAM-DBA
View my complete profile

Blog Archive

  • ►  2025 (2)
    • ►  January (2)
  • ►  2022 (2)
    • ►  October (1)
    • ►  February (1)
  • ►  2020 (2)
    • ►  December (1)
    • ►  February (1)
  • ▼  2018 (9)
    • ▼  December (7)
      • gather stat
      • check indexes status
      • backup pro eod . par
      • pre eod backup and copy to new server
      • Database size
      • Configuring Clients for Environments with Both Sha...
      • Select object tablespace
    • ►  November (2)
  • ►  2017 (3)
    • ►  November (1)
    • ►  September (1)
    • ►  July (1)
  • ►  2016 (1)
    • ►  December (1)
Simple theme. Powered by Blogger.