Moving tables from one tablespace to another

From: <cfischer_at_ancillary.utmrad1.utmb.edu>
Date: 1996/01/08
Message-ID: <4cs3b8$dev_at_atlantis.utmb.edu>#1/1

I have been given the task of upgrading/moving an application. The tables are currently in Oracle v6 database but they are all in the system tablespace. I need to move them to an Oracle7 db on another machine and I need to put the tables in an application data tablespace and the indexes in an index tablespace. Everything is under one user. I know I can export the user but when I import it it wants to put it into the system tablespace again. How do I convince it that that is not the right thing to do? Do I have to edit the export file and change ALL the references?(Yuk)

please post or send replies to cfischer_at_ancillary.utmrad1.utmb.edu

Thanks Received on Mon Jan 08 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Dan Daley: "Re: Using symbolic links for data files ??"
Previous message: Advanced Information Systems Group: "US-FL Project Lead - DB2, Oracle 7.0, JAD and OO Design"
Next in thread: Wayne Balmer: "Re: Moving tables from one tablespace to another"
Reply: Ed White: "Re: Moving tables from one tablespace to another"
Reply: Chuck Hamilton: "Re: Moving tables from one tablespace to another"
Reply: Loren Budd: "Re: Moving tables from one tablespace to another"
Reply: Martin Stoddard: "Re: Moving tables from one tablespace to another"
Reply: Stuart Hemming: "Re: Moving tables from one tablespace to another"
Maybe reply: Brian Graham: "Re: Moving tables from one tablespace to another"
Reply: Wayne Balmer: "Re: Moving tables from one tablespace to another"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message