Using different set of data

Hello everybody,

Here's my problem :

We need to do simulation about different set of data and for that we need to load in a database one specific set of data.

We have several solutions but any of them satisfy us : 1) export/import : too long for 300M of data 2) impossibily to use synonym due to our application structure

except this one :
Can we do this :
- take offline the tablespace (containing all the tables and data we
need)
- rename the datafile associated with the offline tablespace
  (to point to another datafile with the same structure like tables but not the same data)
- take online the tablespace

Does it work ????
If it works there is another problem : what happen for example if there is difference between the structure of the 2 datafiles For example we had to alter a table in the first tablespace/datafile and after we do the operation of renaming the datafile but containing the old
definition of the table before the alter statement. What happens ?? Do we get the old
definition or an inconsistance database or other thing ????

And more generaly does anyone has some experience about working with several
set of data (for simulation) ???

Thanks in advance for our answers, it's a very important problem for us

Regards

Olivier Received on Wed Nov 18 1998 - 10:42:23 CST