Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Jai Shree Ram Oracle
  • alter database backup controlfile to trace Oracle
  • on IBM-AIX for display Linux/Unix
  • export import with parameter file. Oracle
  • SAT Mathematics 10 questions and answer at the end. Uncategorized
  • Oracle Material from OTN Oracle
  • oracle 11g RAC on vmware Oracle
  • switchlogfile.sh Linux/Unix
  • Backup and Recovery Scenarios Oracle
  • TRUNCATE table and disabling referential constraints. Oracle
  • Gathering statistics with DBMS_STATS Oracle
  • compile_inv.sql Oracle
  • Sort with ASCII order and Numeric Order Linux/Unix
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1 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

  • To find explain plan for a statement that occurred in past. Oracle
  • FGA Part-I Oracle
  • Oracle10g – Using SQLAccess Advisor (DBMS_ADVISOR) with the Automatic Workload Repository Oracle
  • Good links for x$ tables in oracle. Oracle
  • create database syntax Oracle
  • Find All internal Parameters 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 (402)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (350)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • 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.sql23-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
  • Creating a Container Database using dbaascli08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle
  • refre.sql for multitenant Oracle
  • Committing distributed transaction using commit force Oracle
  • More info about /proc folder and its relation with processes. Linux/Unix
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
  • Mutating Table Error while using database trigger Oracle
  • lck.sql Oracle
  • To find all disk io ( EMC as well as local) Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme