andy wrote:
>
> On Oracle 7.3.4 i have created a user and load data on it. His
> tablespace is called TB1.
> I would like to load his data to another tablespace TB2.
> Making an export, drop the user, recreate user with new TB2 default
> tablespace, load data. Data will be load on TB1 tablespace.
> The only way is delete TB1 tablespcae before loading data?
>
> Thanks in advance.
>
> Andy.
After you recreate this user, recreate all tables and indexes, then
import.
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Thu Oct 25 2001 - 07:57:25 CDT
