Re: Problems Copying User Tables To New Tablespace

In article <3A88380B.B58BA4E3_at_umich.edu>, Ken says...
>
>Greetings,
>
> I've looked in the FAQ (Oracle Underground) but the solutions I found
>did not work for me, so I was hoping somebody here could help me out.
>
> What I'm basically trying to do is copy a user's tables into a new
>tablespace. We have a a development and staging user set up to use the
>same table spaces. I need to get the staging users tables to a new
>tablespace. This is what I did:
>
>1) Created new tablespace, "staging".
>2) Created a new "new_stage" user and granted connect and resource to
> it's default table space which is "staging", (the newly created
> tablespace).
>3) Exported the old staging users tables using the "user" option on the
> export.
>4) Imported the tables using the "fromuser=old_stage",
> "touser=new_stage" options.
>
> However, the tables all imported back into the original tablespace, and
>there is nothing in the new tablespace I have created.
>
> What did I miss?
>
>--
>Ken Hammer
>Information Technology Division
>University Of Michigan
>khammer_at_umich.edu

In order to do this
a) the user new_stage shouldn't have unlimited tablespace privilege b) it should have quota (unlimited) on the new tablespace *only!*

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Feb 20 2001 - 12:16:59 CET