Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • pvm_pre_change.sql Oracle
  • SQL Server: How to see current transactions or requests SQL Server
  • online_bkup.sql Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • find_arc.sql Oracle
  • Implementation of key based authentications Linux/Unix
  • on IBM-AIX for display Linux/Unix
  • DBMS_PROFILER for tuning PLSQL programs. Oracle
  • mutex in Oracle 10.2.0.2 or Oracle 10g Oracle
  • MYSQL for Oracle DBA MYSQL
  • Deleting first line and lastline of a file using sed Linux/Unix
  • replace alphabets using sed Linux/Unix
  • Create type and Grant on it. Oracle
  • find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
  • get_vmstat.ksh 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

  • switchover for primary database Oracle
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • Find sort details from Db find_sort.sql Oracle
  • How can I tell if ASO is installed ? Oracle
  • good note for shared pool tunnig 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 check whether standby is recovering properly or not?? Oracle
  • sbind.sql Find Bind variable from sql_id sqlid Oracle
  • To find all disk io ( EMC as well as local) Linux/Unix
  • eplan.sql Oracle
  • alter database backup controlfile to trace Oracle
  • login.sql Oracle
  • Pending Transaction Neighbors Script Oracle
  • fkwoindex.sql /* Find FK without Index */ Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme