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