Re: multiple schema in a database ???

2001-05-07 Thread William Beilstein
Having multiple schemas is a very normal part of an Oracle Database. For example, our current database has 70 different schemas [EMAIL PROTECTED] 05/07/01 03:00AM Andrea Oracle schrieb: Hi all, We'll have a meeting about the following issue: Due to large amount of transactions each

Re: multiple schema in a database ???

2001-05-07 Thread William Beilstein
Oh by the way, an easy way to set up the same structure for each user is to build all the tables in a setup schema, then do the following. 1) Export everything in the setup schema using the following command exp userid=setup/pass file=setup.exp 2) Create the new schema (user), making sure to

RE: multiple schema in a database ???

2001-05-07 Thread Rao, Maheswara
Ours is ASP environment and each customer has a different schema. Make sure 1. Your database BR procedures are correctly implemented and tested with recovery scenarios. 2. If possible, take an export and incremental exports and test your exports. Rao [EMAIL PROTECTED] -Original