Re: User Cloning

Mahesh Anand <manand_at_usa.net> wrote in article <346217AA.8F9410E8_at_usa.net>...
> Import does not Alter tables or drop tables if it is already exists.

If you are using Oracle 7, then on import you need to set the IGNORE parameter to YES. This will ignore the error on creating the table, and enable Oracle to only import the data into that table. This will let you overwrite existing objects. (The default for this flag changed between Oracle 6 and Oracle 7).

If your tables are very large, you may want to set the COMMIT=Y parameter, along with a value for BUFFER. (Buffer should be at least large enough to handle the single largest row imported. (This will affect performance, but will be worth it if you may not have a sufficiently large rollback segment.)

Export/import really helps a lot in test environments. You are on the right track. Good luck.

-- 
Peaches	  http://miso.wwa.com/~fsgchi 
	  reply to: fsgchi at wwa dot com
What lies before us, and what lies behind us, are tiny matters
compared to what lies within us...	--Ralph Waldo Emerson