RE: tablespaces ddl extract script

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'. 
scale=9
-201326592.-.589934592
-201326592.589934592

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 9.2.0.7 system,
 which has 8GB datafiles,
 it gives this number from the GET_DDL,

 -201326592.-.589934592

What gives ???

From dba_data_files in bytes it has 8388608000

Georgette

Other related posts: