Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
  • Benefits and Usage of RMAN with Standby Databases Oracle
  • Find_table_size.sql Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • Rownum with Order by Oracle
  • PLSQL Table Syntax 2 Oracle
  • Oracle 11g Training on 29JAN1010 Oracle
  • restarting network in linux Linux/Unix
  • find_encr_wallet.sql Uncategorized
  • ORACLE_SID in sqlplus Oracle
  • Good RAC & Standby Notes Oracle
  • T-SQL Vs PL/SQL Syntax SQL Server
  • Read CSV file using PySpark Python/PySpark
  • Good Site for Oracle Internals Oracle
  • Rman Notes -1 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

  • How to choose Driver table in SQL statement Oracle
  • Histogram Overview Oracle
  • FRA Information. Oracle
  • Oracle 11g Environment Setup Oracle
  • ORA-4031 issue and solution on 09-MAY-2008 Oracle
  • Another export with Query Oracle

Leave a Reply Cancel reply

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

Categories

  • AMC10 (0)
  • 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 (9)
  • Videos (0)

Recent Posts

  • Tutornet.US — Source of excellent learning14-Oct-2026
  • OCI Infrastructure Patching14-Oct-2026
  • Free API credits for AI models14-Oct-2026
  • AMC1020-Sep-2026
  • 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

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • get_vmstat.ksh Linux/Unix
  • Search and replace pattern Linux/Unix
  • How to change hostname in Linux Linux/Unix
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle
  • How to know Number of CPUs on Sun Box Linux/Unix
  • Ports used by Oracle Software Oracle
  • My Minimum Tuning Programs Oracle
  • ORA-4031 issue and solution on 09-MAY-2008 Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme