Re: Duplicate Tables with indexs

Is he Spanish? ;-)

CREATE USER <new schema name>
IDENTIFIED BY <password>
DEFAULT TABLESPACE <default tablespace>
TEMPORARY TABLESPACE <temp tablespace>;

GRANT CREATE SESSION <new schema name>;

Then, export from the original schema followed by an import something like this:

imp system/<system password> file=<file_name> fromuser=<original_schema> touser=<new schema>

Hope this helps. Received on Wed Oct 19 2005 - 10:40:37 CDT