Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Mutating Table Error while using database trigger Oracle
  • EXTPROC Oracle
  • More info about /proc folder and its relation with processes. Linux/Unix
  • Changing default shell Linux/Unix
  • When error comes for temporary tablespace with version <= 9i Oracle
  • Shuffle an array PHP/MYSQL/Wordpress
  • Jai Shree Ram Oracle
  • Optimizer SORT Operations Oracle
  • Jai Shree Ram Oracle
  • dbinv.sql Oracle
  • v$backup.status information Oracle
  • Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle
  • To see mem usage and CPU usage system wide. Linux/Unix
  • catting.sh Linux/Unix
  • temp_use.sql diplays usage of temp ts 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

  • Jai Shree Ram Oracle
  • useful dg links Oracle
  • Library cahe Latches and internal explaination Oracle
  • Good Doc 28-JUN-2006 Oracle
  • Export With Query Another Example. Oracle
  • DBA_HIST_SQLSTAT contents 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
  • JSON/XML Types in Oracle Oracle
  • SQL_PROFILE – I explaination Oracle
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • All About oracle password and security from metalink Oracle
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • How to analyze statspack or AWR report. Oracle
  • Display the top 5 salaries for each department using single SQL Oracle
  • Oracle Metalink useful notes Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme