oracle

Sunday, 5 February 2023

Fetching the data in excel sheet

 set markup html on spool on

spool segment_tablespace.xls

select tablespace_name from dba_segments;

spool off

Posted by kundan.oradba at 08:51
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

kundan.oradba
View my complete profile

Blog Archive

  • ▼  2023 (23)
    • ►  March (7)
    • ▼  February (16)
      • Resource limit
      • Fetching the data in excel sheet
      • Partitioned table
      • Objects in the database.
      • Scheduled jobs
      • Temp tablespace datafile
      • archive destination change
      • DB Link
      • Connectivity
      • Tablepsace and datafile command example
      • DDL
      • Table, Schema & Database size
      • killing oracle session
      • v$session
      • SQL Gather stats job running since long time
      • Export and import migration 12cr2 to 19c
  • ►  2022 (3)
    • ►  May (3)
  • ►  2019 (3)
    • ►  March (3)
  • ►  2018 (2)
    • ►  November (1)
    • ►  January (1)
  • ►  2017 (5)
    • ►  December (1)
    • ►  January (4)
  • ►  2016 (12)
    • ►  November (2)
    • ►  October (4)
    • ►  August (3)
    • ►  July (2)
    • ►  April (1)
Watermark theme. Powered by Blogger.