Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Wait time tuning research Oracle
  • before_trunc.sql Before Truncate table needs to execute following: Oracle
  • UTL_FILE test program Oracle
  • .profile Linux/Unix
  • ext#.sql Oracle
  • Python class import from different folders Python/PySpark
  • All Hints for Oracle Databases Oracle
  • Finding Oracle Patches with opatch Oracle
  • Find All internal Parameters Oracle
  • sess_server.sql Oracle
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • Trace a SQL session from another session using ORADEBUG Oracle
  • standard Monitoring – 1 Oracle
  • moving lob object to other tablespace lob_mvmt.sql Oracle
  • SQLPLUS COPY command Precautions. 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

  • export import with parameter file. Oracle
  • Error Handling in Proc Oracle
  • Oracle 11g Training on 29JAN1010 Oracle
  • Roles and Stored Procs II Oracle
  • Exadata Basics Oracle
  • DBMS_JOB all example Oracle

Leave a Reply Cancel reply

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

Categories

  • AMC10 (0)
  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (6)
  • Videos (0)

Recent Posts

  • AMC1020-Sep-2026
  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • 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.sh23-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

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • How to connect to Oracle Database with Wallet with Python. Oracle
  • AWR settings- MMON is not taking snapshot. Oracle
  • get_vmstat.ksh Linux/Unix
  • Distributed Transaction Troubleshooting. Oracle
  • Find Time Consuming SQL Statements in Oracle 10g Oracle
  • Kernel Parameters for Solaris Linux/Unix
  • Running select from V$ views from remote server Linux/Unix
  • Oracle Data Direct to TAPE Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme