Forum OpenACS Q&A: Response to Oracle import too slow?

Collapse
Posted by Jeff Davis on
Bruno, one way to do it is to edit the user and tablespace directly in the exported binary (which worked for me with versions  8.0.5-8.1.6, never tried
it with any other versions). cf http://www.galileo.edu/obonilla/writing/oracle/

The other way is to change the permissions for the user which unfortunately I am not entirely sure how to do...
something like "revoke unlimited tablespace from username;" and maybe some other stuff.  I think there might still be problems with clobs though.
This page talks about it for v7 but I would guess things are similiar for v8.
http://www.fors.com/orasupp/rdbms/dba/18214_1.HTM