Re: export to a tablespace with different name..

From: Allan Nelson <nels212_at_austin360.com>
Date: Sun, 16 Aug 1998 11:10:05 -0500
Message-ID: <35D7045D.4D3F6175@austin360.com>

sunita_at_postoffice.worldnet.att.net wrote:

> I want to export the data from Database A to database B.
> Problem is the tablespace names are different in the
> two databases.
>
> What is the work around it?
>
> Currently I am using teh copy command to copy
> each table from A to B.
>
> Any ideas...

If the schema owners are the same in both databases you can extract the table creation ddl from the export file and edit it to match the second databases' tablespaces. Then set ignore = y for the import and off you go.

Allan Received on Sun Aug 16 1998 - 11:10:05 CDT