Re: getting data out of system tablespace

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Wed, 8 Sep 1999 12:44:03 -0400
Message-ID: <7r640t$bsr$1@winter.news.rcn.net>

Hi Larry,

It depends on the version of Oracle you are using. The following will work for 7.3.x (sorry I don't know what x is):

        ALTER TABLE imp_table RENAME TO old_imp_table;
        CREATE TABLE imp_table
            TABLESPACE new_tablespace
            AS SELECT * FROM old_imp_table;
        DROP TABLE old_imp_table;

regards
Jerry Gitomer

Larry Pettit wrote in message ...
>I received an import file that from another system that I need
to load. I
>created another user, assigned it to a user_data tablespace and
even did the
>import load under that user id, but it still put it into the
system
>tablespace. How can I move it into another tablespace?
>
>
>
Received on Wed Sep 08 1999 - 11:44:03 CDT