Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to start CRS manually Oracle
  • Very clear article about oracle dataguard Oracle
  • DBMS_PROFILER for tuning PLSQL programs. Oracle
  • upload.html PHP/MYSQL/Wordpress
  • DB Console Mainenance. Oracle
  • MYSQL for Oracle DBA MYSQL
  • Roles and Stored Object behaviour Oracle
  • DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
  • How to change hostname in Linux Linux/Unix
  • V$transaction notes for finding XID composition. Oracle
  • Find Stale DR Physical Standby Oracle
  • Roles and Stored Procs II Oracle
  • All About oracle password and security from metalink Oracle
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • Adding or Dropping Online Redo Log Files When Physical Standby in place 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

  • Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
  • Database link password in user_db_links Oracle
  • Free conference number from http://www.freeconference.com Oracle
  • eplan.sql Oracle
  • Rman Notes -1 Oracle
  • Privileges Required to Create Procedures and Functions that uses objects from other schema. 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 (149)
  • MYSQL (5)
  • Oracle (395)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (343)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • prepfiles.sh for step by step generating pending statistics files10-Mar-2026
  • tracksqltime.sql05-Mar-2026
  • Complete Git Tutorial for Beginners25-Dec-2025
  • Postgres DB user and OS user.25-Dec-2025
  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • Transfer SQL Profiles from One database to other database. Oracle
  • How to calculate PROCESSES parameter Oracle
  • Running select from V$ views from remote server Linux/Unix
  • Checking SQL Server Version SQL Server
  • How to set Processes Parameter Oracle
  • oradebug ipcrm ipcs Oracle
  • Display the top 5 salaries for each department using single SQL Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme