Thread: 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