Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • Rename Oracle Instance Name Oracle
  • Some OS level threshold for performance. Linux/Unix
  • Windows based Command line mailing program like mailx (Sednmail for windows) PHP/MYSQL/Wordpress
  • Which environment is used by currently running process ( Very good) Linux/Unix
  • Rownum with Order by Oracle
  • Find_planinfo.sql Oracle
  • scripts to take listener.log backup Linux/Unix
  • temp_use.sql diplays usage of temp ts Oracle
  • Sort with ASCII order and Numeric Order Linux/Unix
  • Optimizer SORT Operations Oracle
  • How to choose Driver table in SQL statement Oracle
  • Find sort details from Db find_sort.sql Oracle
  • sql_plan9i.sql Oracle
  • sid_wise_cursor.sql find open cursor basis on username or SID 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

  • First Entry in RAC Oracle
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • 751131.1 New Article Error 2819 While Requesting a Systemstate Dump Oracle
  • Oracle Material from OTN Oracle
  • Renaming Oracle Instance Name Oracle
  • Index Range Scan 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 (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • SQL Server: How to see historical transactions SQL Server
  • Configure ssh authentications for RAC Oracle
  • Rownum with Order by Oracle
  • Find total file sizes Linux/Unix
  • To Find Orphan OS processes. Linux/Unix
  • telnet listening Linux/Unix
  • cache buffer chain latch Oracle
  • Paste command syntax Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme