Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • tracksqltime.sql Oracle
  • SQL_PLAN.sql for checking real execution plan Oracle
  • Explain Plan Doesn’T Change For Sql After New Statistics Generated Oracle
  • DB Console Mainenance. Oracle
  • How to know current SID Oracle
  • Jai Shree Ram Oracle
  • Index Range Scan Oracle
  • to see when crontab is changed. Linux/Unix
  • Search and Replace vi editor command. Linux/Unix
  • How to change hostname in Linux Linux/Unix
  • Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
  • How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
  • send attachment from unix-shell script Linux/Unix
  • find_open_cur.sql Find open cursorts per session Oracle
  • 10g oem configuration 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

  • arch_configUOCIOTTO.ora Oracle
  • Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • All About Trace Fils Oracle
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause 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
  • Wait Based Tuning Step by step with SQL statement Oracle
  • Sending SQLPLUS output in HTML format Oracle
  • To see how much time or progress of long transaction Oracle
  • compile_inv.sql Oracle
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
  • Generating XML from SQLPLUS Oracle
  • To find explain plan for a statement that occurred in past. Oracle
  • find_arc.sql Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme