Blogs about: Datafile
Featured Blog
Display datafile usage
Display datafile usage. src: http://www.oracle-consultant.co.uk column tsname format a20 heading 'Tablespace Name' column flname format a70 heading 'Filename' column siz format 999,999,990 heading 'Fi… more →
Andre Broers' personal blog
ORA 3297 when resizing a datafile
carlosacostaalamo wrote 3 days ago: Sometimes we want to shrink a datafile and we get the ORA-3297 error, what? but if there is enough s … more →
Naming Directories in Oracle Installations On Windows (Optimal Flexible Architecture - OFA)
— 1 comment
Emrah Becer wrote 2 weeks ago: The Optimal Flexible Architecture (OFA) standard is a set of file naming and configuration guideline … more →
Script - Database structure and file location
Gavin Soorma wrote 5 months ago: set pagesize 500 set linesize 130 Prompt Prompt Control Files Location >>>> col name for … more →
RECOVERING FROM A LOST DATAFILE IN AN UNDO TABLESPACE
Luis Moreno Campos wrote 7 months ago: Today we post a very important life saving Metalink Note, and the one that most challenges the DBA k … more →
Timestamps within ASM
John Hallas wrote 8 months ago: Blogs are normally about how to resolve things or sharing some newly found information. In this case … more →
Unable to extend temp segment by 1024 in tablespace abc?
hashfactor wrote 1 year ago: Oracle tried to allocate some space in the mentioned tablespace but could not find space there. Easi … more →
How to Add Capacity in Existing Tablespace
macdba wrote 1 year ago: First of all, A tablespace is the logical storage unit in Oracle Database and may consist one or mor … more →
How to move an Outlook 2007 DataFile ?
— 4 comments
basskozz wrote 1 year ago: I decided to break free from Google Apps webGUI (a.k.a. Gmail) and start using Outlook to access my … more →
How to move datafiles in temp tablespace?
Amin Jaffer wrote 1 year ago: One can’t move the temp tablespace during mount stage like other datafiles using “ALTER … more →
How does Diablo build its maps?
SteelGolem wrote 1 year ago: I took a bit of time to try and look up how Diablo 1 loads or creates its maps – and I came up … more →
Display datafile usage
broersa wrote 3 years ago: Display datafile usage. src: http://www.oracle-consultant.co.uk column tsname format a20 heading 'Ta … more →
