From: lthompson003@yahoo.com (L Thompson)
Newsgroups: comp.databases.oracle
Subject: Tablespace DDL
Date: 11 Nov 2002 10:15:13 -0800
Organization: http://groups.google.com/
Lines: 6
Message-ID: <a8596b26.0211111015.172545bc@posting.google.com>
NNTP-Posting-Host: 198.81.129.193
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1037038513 10947 127.0.0.1 (11 Nov 2002 18:15:13 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 11 Nov 2002 18:15:13 GMT


Anyone know of a way that I can pull the DDL for the tablespaces out
of a database.  I am moving an Oracle database from one server to
another.  The two database have different blocksizes so I cannot use
the transportable tablespace feature.  The new database is 8.1.7 and
the old one is 8.0.3.  I am trying to avoid going in and manually
recreating all the tablespaces in the new database.