Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to start CRS manually Oracle
  • find_open_cur.sql Find open cursorts per session Oracle
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • Jai Shree Ram Linux/Unix
  • How to analyze statspack or AWR report. Oracle
  • pvm_metric.sql for gathering report from vmstat tables Oracle
  • On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
  • Rman Notes -1 Oracle
  • Linux CPU info. Linux/Unix
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • Rename Tablespace Oracle
  • find_cons.sql Oracle
  • Database logon trigger issue Oracle
  • Useful Solaris Commands on 28-SEP-2005 Linux/Unix
  • Difference between SYNC and AFFIRM 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

  • Wait Based Tuning Step by step with SQL statement Oracle
  • OEM-troubleshooting on 20-MAY-08 Oracle
  • cache buffer chain latch Oracle
  • Very clear article about oracle dataguard Oracle
  • Formatter Explain plan Output 1 Oracle
  • Oracle 11g Environment Setup 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 (149)
  • MYSQL (5)
  • Oracle (400)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (348)
  • SQL Server (6)
  • Uncategorized (3)
  • Videos (0)

Recent Posts

  • 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
  • Creating a Container Database using dbaascli08-Apr-2026
  • track_autoupgrade_copy_progress.sql01-Apr-2026
  • refre.sql for multitenant01-Apr-2026
  • prepfiles.sh for step by step generating pending statistics files10-Mar-2026
  • tracksqltime.sql05-Mar-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • grep multuple patterns Linux/Unix
  • get_vmstat_solaris Oracle
  • Proc Compilation Oracle
  • Good RAC & Standby Notes Oracle
  • Mutating Table Error while using database trigger Oracle
  • Another Tuning Article for subheap of shared pool Oracle
  • Finding locked objects Oracle
  • How to stop OCSSD Daemon Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme