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

Posted by Bruno Mattarollo on
I have a question similar to Andrews'.

I need to import data from a production database into two different tablespaces (two different users). Using 'exp' doesn't allow me to do that, as it always try to create in the tablespace with the username used while doing 'exp'. I want to import into 'development' and 'staging' but I don't want to have two different oracle instances, I want to use two different users. Is this possible without having to do, as Andrew says, create scripts that will write data out in formats for SQLLLDR?

Thank you in advance,