Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • sbind.sql Find Bind variable from sql_id sqlid Oracle
  • dbms_job.submit example Oracle
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
  • get_vmstat_linux Oracle
  • Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
  • This is im telling Kishore Oracle
  • How to Use DBMS_STATS to Move Statistics to a Different Database Oracle
  • USER_TABLES.Freelists Oracle
  • For Perl DBI installation and testing program PHP/MYSQL/Wordpress
  • MYSQL and Oracle Comparison for Oracle DBA MYSQL
  • When to rebuld B-tree index Oracle
  • DBMS_STATS Metalinks Notes Oracle
  • on IBM-AIX for display Linux/Unix
  • Vivek’s egrep commands to trace problem. (on linux x86-64) Linux/Unix
  • ORA-8031 issue and solution if it is occuring due to truncate. 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

  • RAC with RHEL4 and 11g Oracle
  • Good Site for Oracle Internals Oracle
  • Oracle 10g Wait Model Oracle
  • Caching sequence in Memory Oracle
  • GSQ.sql Oracle
  • Jai Shree Ram 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
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • SAT Mathematics 10 questions and answer at the end. Uncategorized
  • To find all disk io ( EMC as well as local) Linux/Unix
  • How to hide author name in WordPress BLOG PHP/MYSQL/Wordpress
  • scripts to take listener.log backup Linux/Unix
  • Find all users who have DML privileges Oracle
  • How to sort list of files on basis of their sizes. Linux/Unix
  • Single character replacement in Unix Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme