Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • mutex in Oracle 10.2.0.2 or Oracle 10g Oracle
  • get_vmstat_solaris Oracle
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • Python class import from different folders Python/PySpark
  • Find_table_size.sql Oracle
  • Oracle Internal Good Websites 1 Oracle
  • create user with unlimited quota Oracle
  • 272332.1 CRS 10g Diagnostic Collection Guide Oracle
  • get_vmstat.ksh Linux/Unix
  • ORA-3136 Oracle
  • Jai Shree Ram Oracle
  • send attachment from unix-shell script Linux/Unix
  • For Perl DBI installation and testing program PHP/MYSQL/Wordpress
  • Paste command syntax Linux/Unix
  • Getting started with notebook Python/PySpark

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

  • Find sort details from Db find_sort.sql Oracle
  • Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1 Oracle
  • Rman Notes -1 Oracle
  • New OFA for 11g Oracle
  • sqlnet.ora paramters Oracle
  • SQLPLUS COPY command Precautions. 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
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • Pending Distributed Transations Oracle
  • xargs use Linux/Unix
  • The most important Tuning Notes Oracle
  • setting prompt display with .profile Linux/Unix
  • Jai Shree Ram Linux/Unix
  • find_open_cur.sql Find open cursorts per session Oracle
  • Very Good Oralce Internal Tuning Book Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme