Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • dbms_job.submit example Oracle
  • Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
  • Roles and Stored Procs II Oracle
  • Important Script Method for tuning Oracle
  • track_autoupgrade_copy_progress.sql Oracle
  • refre.sql Oracle
  • Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle
  • How to know Number of CPUs on Sun Box Linux/Unix
  • Getting started with notebook Python/PySpark
  • Recovering lost SYS password Oracle
  • SAN Linux/Unix
  • JSON/XML Types in Oracle Oracle
  • login.sql Oracle
  • eplan9i.sql Oracle
  • OEM-Commnds 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

  • Free conference number from http://www.freeconference.com Oracle
  • Parallel DML Oracle
  • moving lob object to other tablespace lob_mvmt.sql Oracle
  • fkwoindex.sql /* Find FK without Index */ Oracle
  • Implementing Listener Security Oracle
  • Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() 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 (403)
  • 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

  • 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.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

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • tblwopk.sql tablewopk.sql Oracle
  • My Test Case On 21-OCT-2005 Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • Space padding in korn shell Linux/Unix
  • sbind.sql Find Bind variable from sql_id sqlid Oracle
  • How to know Number of CPUs on Sun Box Linux/Unix
  • Useful Solaris Commands on 28-SEP-2005 Linux/Unix
  • AWR settings- MMON is not taking snapshot. Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme