Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • Jai Shree Ram Oracle
  • Generate SSH without password authentication. Linux/Unix
  • Find Plan Hash value fphv.sql Oracle
  • Oracle Support Metalink ID 161818.1 Oracle
  • find_string_in_database.sql Oracle
  • Nice notes on wait events Oracle
  • sid_wise_sql.sql Oracle
  • note id 373303.1 Linux/Unix
  • Rownum with Order by Oracle
  • Oracle 11g RAC on OEL 5 and Vmware 2 Oracle
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
  • Very clear article about oracle dataguard Oracle
  • avail.sh ( find filesystem spae usage) 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

  • plan10g.sql good Oracle
  • Proc Compilation Oracle
  • Changing the Global Database Name Oracle
  • Finding locked objects Oracle
  • longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
  • UNderstand and eliminate Latch contention. Oracle

Leave a Reply Cancel reply

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

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • How to set Processes Parameter Oracle
  • How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
  • Virtual Indexes in Oracle Oracle
  • Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
  • changing kernel parameter in Oracle Enterpise Linux Linux/Unix
  • Vivek Tuning for Row Locks. Oracle
  • Set Role explaination. Oracle
  • Oracle 11g Environment Setup Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme