RE: tablespaces ddl extract script

  • From: "Gogala, Mladen" <MGogala@xxxxxxxxxxxxxxxxxxxx>
  • To: "'Georgette.Cornio@xxxxxxxxxxxxx'" <Georgette.Cornio@xxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 12 Oct 2005 16:39:35 -0400

Every good system should have command called bc. Here is what it gives:

bc 1.06
Copyright 1991-1994, 1997, 1998, 2000 Free Software Foundation, Inc.
This is free software with ABSOLUTELY NO WARRANTY.
For details type `warranty'. 

So, DBMS_METADATA.GET_DDL will give you -201326592.589934592 which is a
perfectly legal number belonging to R. It is, of course, completely
usless but it is completely legal and you don't even need Taylor series 
to represent it. I am looking forward to the moment when Oracle routines
will start returning complex numbers to use as input to "create" commands.
That will be completely in accordance with the super-string theory according
to which space-time continuum has 11 dimensions. For those who don't
remember high school, complex numbers are algebraic closure of R and
each number is represented as a sum of its real and imaginary part. The
phrase "algebraic closure" means, of course, that every polynomial with the
coefficients in C has at least one solution in the field C.
Now I've been as helpful as the Oracle Corp. with its return values. Am I
great or what? 

Mladen Gogala
Ext. 121
-----Original Message-----
From: Cornio, Georgette Ms USACFSC [mailto:Georgette.Cornio@xxxxxxxxxxxxx] 
Sent: Wednesday, October 12, 2005 12:15 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: tablespaces ddl extract script

When I run this on my system,
 which has 8GB datafiles,
 it gives this number from the GET_DDL,


What gives ???

From dba_data_files in bytes it has 8388608000


Other related posts: