NowI have dump of multiple schemas taken using traditional export method. Need to import into a ne
The Data and Index tablespaces on the source are maintained separately. So i need to maintain the same on the new System How do i achieve it?
My understanding if it were to have tablespaces where data and indx were not maintained separately then.... i would go for this approach.
create new user in target db with a new tablespace name Make that tablespace its default tablespace. Grant unlimited quota on that tablespace to thenew user.
export file =<> log =<> fromuser= xyz touser=<xyz> ...rest of the optional parameters. This will take care of the tablespace remapping.
But in my case i have maintain Data and Index tablespaces separately. How do i achieve it... Kindly help !!!