Re: Using export to migrate data

A copy of this was sent to "Matt Skeens" <mskeens_at_xnet.com> (if that email address didn't require changing) On Mon, 21 Jun 1999 16:31:13 -0500, you wrote:

>I need to use export to move multiple tablespaces from 8.0.4 to 8i. I need
>to move each tablespace one at a time. Is there a way I can remove update,
>delete, and insert capabilities on the tablespace while still preserving
>select privileges? From my understanding, the create session privilege
>gives update and insert privileges. Any help is appreciated.

create session does not convery any insert/update privs. they must have been granted in some other fashion.

In any case, "alter tablespace <tablespacename> read only" and "read write" will do it for you.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Jun 22 1999 - 08:18:21 CDT