Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to Make Trace Files Created by Oracle Readable by All Users ? Oracle
  • export import with parameter file. Oracle
  • tblwopk.sql tablewopk.sql Oracle
  • Oracle vs MYSQL Architecture differences (For DBAs) MYSQL
  • How to sort list of files on basis of their sizes. Linux/Unix
  • find_idle_cpu.sql Oracle
  • Paste command syntax Linux/Unix
  • Debugging Shell FIles Linux/Unix
  • OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
  • Recovering lost SYS password Oracle
  • All About oracle password and security from metalink Oracle
  • Default User Profile Oracle
  • Running select from V$ views from remote server Linux/Unix
  • Building Our Own Namespaces with “Create Context” Oracle
  • Goldengate document from Porus 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

  • Library cahe Latches and internal explaination Oracle
  • find_cons.sql Oracle
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
  • myfile Oracle
  • create user with unlimited quota Oracle
  • sqlnet.ora paramters 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 (394)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (343)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Checking SQL Server Version25-Jul-2025

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
  • metalink all dynamic view reference notes. Oracle
  • Identical Dblink Issue… Oracle
  • Resolving RMAN Hung Jobs Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • Oracle Internal Good Websites 1 Oracle
  • Caching sequence in Memory Oracle
  • newupload.html PHP/MYSQL/Wordpress

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme