Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Rownum with Order by Oracle
  • AWR license Oracle
  • Formatter Explain plan Output 1 Oracle
  • RAC 11g with vmware Oracle
  • fkwoindex.sql /* Find FK without Index */ Oracle
  • Oracle Support Metalink ID 161818.1 Oracle
  • PLSQL Table Syntax 2 Oracle
  • DBMS_JOB all example Oracle
  • Restoring a user’s original password 1051962.101 Oracle
  • ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • kill all processes from specific user in solaris. Linux/Unix
  • v$event_name Oracle
  • Good notes for shared pool Oracle
  • SYSOPER Mystery 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

  • Important Script Method for tuning Oracle
  • How to set Processes Parameter Oracle
  • Implementing Listener Security Oracle
  • oradebug ipcrm ipcs Oracle
  • v$backup.status information Oracle
  • find_cons.sql Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025
  • MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • CPU speed on Linux Linux/Unix
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
  • Insert cause enqueue locks Oracle
  • Session_info.ksh Linux/Unix
  • SQL Server Vs Oracle Architecture difference SQL Server
  • Display the top 5 salaries for each department using single SQL Oracle
  • check_copy_progress.sh Linux/Unix
  • True Session Wait Activity in Oracle 10g Verygood Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme