Re: how to backup complete tablespace?

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 1 Oct 1998 16:10:51 -0500
Message-ID: <6v0r4r$173$1@garnet.tc.umn.edu>

Yeah, you could do a complete backup and duplicate everything back at the office, including machine, OS, Oracle release, disks, filesystems.

This is difficult to do unless it is a small and simple application.

Export and import need tablespaces and try to create extents and partitioning that is site specific, etc.

I usually get an export file from 'exp' get the DDL from it and change the DDL so it is not machine specific since it is difficult to match hardware/disk size. I create the database objects, then I load in the data with the import utility 'imp'.

http://www.tc.umn.edu/~hause011/code/ugly_DDL.ksh is what I use to strip the DDL from export/import. Unfortunately I have never seen a DDL from export/import except for this ugly one.

Of course there are many point and click tools to do this sort of stuff but I don't usually think of them as simple or quick. ERWin and Oracle 2K and other reverse engineering tools can get the schemas from a site. But setting up these tools and accessing a customers site is not always as easy as getting an export file. --

Steven Hauser, hause011_at_tc.umn.edu

Phone: (612)626-7135
Fax:   (612)625-6853


---------------------------------------------------------

Received on Thu Oct 01 1998 - 16:10:51 CDT