Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1 Oracle
  • Jai Shree Ram Linux/Unix
  • CPU speed on solaris Linux/Unix
  • MYSQL for Oracle DBA MYSQL
  • Histogram information Oracle
  • How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
  • New OFA for 11g Oracle
  • UNderstand and eliminate Latch contention. Oracle
  • 10g oem configuration Oracle
  • create user with unlimited quota Oracle
  • Library cahe Latches and internal explaination Oracle
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • Pending Transaction Neighbors Script Oracle
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
  • Key Management in Oracle: The Core Issue: Missing Master Key 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

  • Remove duplicate rows from table Oracle
  • Difference between SYNC and AFFIRM Oracle
  • Configure ssh authentications for RAC Oracle
  • Composite Index creation tip from Vivek Oracle
  • oradebug ipcrm ipcs Oracle
  • runon_allcdbs_find_pdbs.sh Linux/Unix

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
  • Parallel DML Oracle
  • Linux CPU info. Linux/Unix
  • Oracle Connections expire_time and firewall Oracle
  • to see when crontab is changed. Linux/Unix
  • plan10g.sql good Oracle
  • Display the top 5 salaries for each department using single SQL Oracle
  • Find total file sizes Linux/Unix
  • get_vmstat_linux Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme