RE: Tablespaces

From: <Stephen.Lee_at_DTAG.Com>
Date: Fri, 2 Jul 2004 09:09:05 -0500
Message-ID: <D6339830FC73944E889CC3CEADDB205B079094D3@bu-dtagpo1.tracs.com>

You also need to grant the user quota unlimited on their default tablespace and be sure the user has quota 0 on the other tablespaces. Also the user must not have any role the gives user privilege to go around the quota. Then import will be forced to create the tables in user's default tablespace.

> -----Original Message-----
> Create the Users and assign them Default Tablespace

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 02 2004 - 09:05:50 CDT