Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Moving schemas between tablespaces

Moving schemas between tablespaces

From: <mikeg12321_at_my-deja.com>
Date: Thu, 25 Jan 2001 22:24:17 GMT
Message-ID: <94q926$9is$1@nnrp1.deja.com>

Heres what I want to do:
I want to create a new user and give him his own tablespace to store data. I want to export a schema from another user and import that schema into the new user's tablespace (so the new schema is owned by the new user). When I try to do this, the import always imports into the original tablespace, no matter that I set the touser=new user, and the new user's default tablespace is the new one I made for him. Any suggestions?

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 25 2001 - 16:24:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US