Table space question

On Friday 02 April 2010 12:44, akp geek wrote:

Hi all -

I have created dump of a database where I have a tablespace
(data_tblspace ) associated with relations. I have restored to a different
server. I created the same table space. Now I need to create an other
database on the same server using the same dump. but I need to have a
different tablespace for all the relations.

Can you please suggest? Do I have to do the restore the
database to the same tablespace first? and then alter the tablespace?

Regards

Maybe something like this (assuming the dump file is in text/sql format):

sed "s/data_tblspace/new_tblspace/g" dump_file > new dump file