Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Handling LOB data in Oracle Oracle
  • scripts to take listener.log backup Linux/Unix
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • Insert cause enqueue locks Oracle
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • All About Trace Fils Oracle
  • Create type and Grant on it. Oracle
  • Find Time Consuming SQL Statements in Oracle 10g Oracle
  • ORA-4031 issue and solution on 09-MAY-2008 Oracle
  • .profile Linux/Unix
  • Jai Shree Ram Oracle
  • Find total file sizes Linux/Unix
  • V$ROLLSTAT status is Full Oracle
  • shutdown linux Linux/Unix
  • Changing unix system clock when Oracle database is running. 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

  • dbinv.sql Oracle
  • How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
  • Implementing Listener Security Oracle
  • sess_server.sql Oracle
  • longtx.sql Oracle
  • Adding Datafile on Primary Server and Impact on Standby Server Oracle

Leave a Reply Cancel reply

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

Categories

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

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • S3 Basic info AWS
  • Load testing on Oracle 19C RAC with HammerDB Oracle
  • When error comes for temporary tablespace with version <= 9i Oracle
  • Oracle Statspack survival Guide Oracle
  • Guide to Linux System Command Mastery Linux/Unix
  • Generate SSH without password authentication. Linux/Unix
  • Korn Shell Arithmatic Linux/Unix
  • Wait Based Tuning Step by step with SQL statement Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme