Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • When error comes for temporary tablespace with version <= 9i Oracle
  • Gathering statistics with DBMS_STATS Oracle
  • Jai Shree Ram Oracle
  • Sort with ASCII order and Numeric Order Linux/Unix
  • Load testing on Oracle 19C RAC with HammerDB Oracle
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle
  • Linux CPU info. Linux/Unix
  • fkwoindex.sql /* Find FK without Index */ Oracle
  • S3 Basic info AWS
  • How to find where datafile is created dbf_info.sql Oracle
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • All About oracle password and security from metalink Oracle
  • how to find VIP from ifconfig Linux/Unix
  • Benefits and Usage of RMAN with Standby Databases Oracle
  • proper cpu stats Linux/Unix

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

  • DBMS_UTILITY PACKAGE Oracle
  • login.sql Oracle
  • How to find where datafile is created dbf_info.sql Oracle
  • Configure ssh authentications for RAC Oracle
  • Multiple listeners Oracle
  • Find all users who have DML privileges 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
  • This is from Temi Oracle
  • default permission on ~/.ssh/authorized_keys2 or authorized_keys Linux/Unix
  • v$backup.status information Oracle
  • find_longsql.sql Oracle
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • telnet listening Linux/Unix
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • Unix command for system configuration Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme