Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Processes Parameter decision Oracle
  • Small sample shell program Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • runsql_once.ksh Linux/Unix
  • Drop database in Oracle 10g Oracle
  • checking connectivity between two servers Linux/Unix
  • Find_table_size.sql Oracle
  • online_bkup.sql Oracle
  • Jai Shree Ram Oracle
  • Reclaim temp tablespace for oracle 8, 8i Oracle
  • find_idle_cpu.sql Oracle
  • get_vmstat_linux Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • How to find where datafile is created dbf_info.sql Oracle
  • refre.sql for multitenant 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

  • CPU Core related projections AWS
  • Finding Oracle Patches with opatch Oracle
  • Good RAC & Standby Notes Oracle
  • EXTPROC Oracle
  • v$backup.status information Oracle
  • 272332.1 CRS 10g Diagnostic Collection Guide 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 (402)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (350)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • 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.sql23-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
  • Creating a Container Database using dbaascli08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Vivek’s egrep commands to trace problem. (on linux x86-64) Linux/Unix
  • How to analyze statspack or AWR report. Oracle
  • tar and untar a dolder with all its subfolder. Linux/Unix
  • V$INSTANCE of Oracle in MYSQL MYSQL
  • My FTP Job Scheduling for www.pvmehta.com PHP/MYSQL/Wordpress
  • scp with ssh2 Linux/Unix
  • metalink all dynamic view reference notes. Oracle
  • Optimizer SORT Operations Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme