Re: Can datafile be resized while instance is open?
Date: Mon, 18 Apr 2011 09:31:17 -0700 (PDT)
Message-ID: <4a8cea78-63e1-4959-91d4-ce5a57ec4de4_at_w9g2000prg.googlegroups.com>
On Apr 15, 7:04 pm, Noons <wizofo..._at_yahoo.com.au> wrote:
> Mladen Gogala wrote,on my timestamp of 16/04/2011 3:24 AM: > > > On Fri, 15 Apr 2011 09:48:45 -0700, Dean wrote: > > >> Hi, I am a newbie administrator. Is it safe to alter datafile size > >> while database is open? > > > And how would you do it with a closed instance? > > LOL! Indeed...
Concatenate unformatted Oracle blocks to the end of the file? Do a tail youremptyattheendfile.dbf|od -c to see what's there...
10017720 \0 : 001 : 242 \0 \0 001 \0 002 t \0 \0 \0 \0
\0
10017740 \0 001 004 002 323 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10017760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10037720 \0 : 001 : 242 \0 \0 001 \0 002 u \0 \0 \0 \0
\0
10037740 \0 001 004 002 322 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10037760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10057720 \0 : 001 : 242 \0 \0 001 \0 002 v \0 \0 \0 \0
\0
10057740 \0 001 004 002 321 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10057760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10077720 \0 : 001 : 242 \0 \0 001 \0 002 w \0 \0 \0 \0
\0
10077740 \0 001 004 002 320 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10077760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10117720 \0 : 001 : 242 \0 \0 001 \0 002 x \0 \0 \0 \0
\0
10117740 \0 001 004 002 337 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10117760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10137720 \0 : 001 : 242 \0 \0 001 \0 002 y \0 \0 \0 \0
\0
10137740 \0 001 004 002 336 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10137760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10157720 \0 : 001 : 242 \0 \0 001 \0 002 z \0 \0 \0 \0
\0
10157740 \0 001 004 002 335 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10157760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10177720 \0 : 001 : 242 \0 \0 001 \0 002 { \0 \0 \0 \0
\0
10177740 \0 001 004 002 334 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10177760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10217720 \0 : 001 : 242 \0 \0 001 \0 002 | \0 \0 \0 \0
\0
10217740 \0 001 004 002 333 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10217760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10237720 \0 : 001 : 242 \0 \0 001 \0 002 } \0 \0 \0 \0
\0
10237740 \0 001 004 002 332 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10237760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10257720 \0 : 001 : 242 \0 \0 001 \0 002 ~ \0 \0 \0 \0
\0
10257740 \0 001 004 002 331 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10257760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10277720 \0 : 001 : 242 \0 \0 001 \0 002 177 \0 \0 \0 \0
\0
10277740 \0 001 004 002 330 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10277760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10317720 \0 : 001 \0 242 \0 \0 001 \0 002 200 \0 \0 \0 \0
\0
10317740 \0 001 005 002 & \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
10317760 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
\0
*
10337720 \0 \0 001
10337723
(Note to newbies: Don't concatenate unformatted Oracle blocks to the end of a data file. It's just interesting to see things with od.)
jg
-- _at_home.com is bogus. http://www.basementcoders.com/transcripts/James_Gosling_Transcript.htmlReceived on Mon Apr 18 2011 - 11:31:17 CDT