Re: [GENERAL] Tablespaces and indexes

2005-03-28 Thread Bruno Wolff III
On Sun, Mar 27, 2005 at 19:46:41 -0600, > > Related question: Once I switch the 8.0.1 system over to be the production, > can I reverse the direction and restore .dmp files on the 7.4.5 system or > are the tablespace terms in the dump files going to cause problems? The 8.0.1 dumps will probably

[GENERAL] Tablespaces and indexes

2005-03-27 Thread Mike Nolan
I'm trying to move over 50 tables (several over 500MB each) from a 7.4.5 database to 8.0.1 on a regular basis during system testing. (The 8.0.1 system will become the production system soon, probably next month.) I'd like to have the data table and its indexes built in separate tablespaces on