Re: how do i copy tablespace?
From: MotoX <rat_at_tat.a-tat.com>
Date: Tue, 6 Oct 1998 12:00:09 +0100
Message-ID: <907671508.19077.0.nnrp-10.c2de712e_at_news.demon.co.uk>
Date: Tue, 6 Oct 1998 12:00:09 +0100
Message-ID: <907671508.19077.0.nnrp-10.c2de712e_at_news.demon.co.uk>
Madhu Cherukuri wrote in message <6v7svc$113_at_bgtnsc02.worldnet.att.net>...
>I think you can do so by using
>the IMP/EXP (Import/Export tools of Oracle)
>But if the database is very big, then you may have
>portability problem.
Well, not so much a 'portability' problem, but you point is valid - the time involved maybe excessive for a large db on a slow server with IMP/EXP.
If the servers and OS releases are the same - and Oracle releases - a cold backup of the db may be a better alternative for a large db. Of course you'll get the entire db, but this may not be a problem. Run a recreate of the control files if the mount points are going to be different.
MotoX. Received on Tue Oct 06 1998 - 13:00:09 CEST