Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • avail.sh ( find filesystem spae usage) Linux/Unix
  • Convert multiple rows to single column Oracle
  • find_err.sql for finding errors from dba_errors. Oracle
  • DBMS_SQL for alter session. Oracle
  • Some OS level threshold for performance. Linux/Unix
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • secure crt settings Linux/Unix
  • cur_sql.sql Oracle
  • Alter procedure auditing Oracle
  • pvm_rbs1.sql (to collect rbs info from db) Oracle
  • Facts about SCN and Rollback Segment Oracle
  • Database logon trigger issue Oracle
  • Finding last recovered file on DR and remove all chanracters before any “/” Linux/Unix
  • Find Multiple levels of object dependencies : depen.sql Oracle
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle

Flowers Resize datafiles

Posted on 02-Mar-2006 By Admin No Comments on Flowers Resize datafiles

In flowers we resize datafile using following command:

alter database resize datafile ‘/path1/filename.dbf’ resize 500M;

this will change that datafles ‘SIZE’ column and allocate that much space for that datafile. If you are having standby database pls make sure that enough space is available for that file expansion.

Oracle, rman-dataguard

Post navigation

Previous Post: age_alert.ksh aging out alert.log
Next Post: Create type and Grant on it.

Related Posts

  • tracksqltime.sql Oracle
  • TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1 Oracle
  • ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle
  • V$ROLLSTAT status is Full Oracle
  • Wait.sql Oracle
  • Error Handling in Proc Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • SYSOPER Mystery Oracle
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • Implementing Listener Security Oracle
  • Export Oracle data and Compress at same time Oracle
  • Oracle Support Metalink ID 161818.1 Oracle
  • Drop tempfiles from database Oracle
  • Linux CPU info. Linux/Unix
  • sid_wise_sql.sql Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme