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 set the temporary tablespace and
default tablespace to the correct tablespaces. Make sure that the user is granted the
CONNECT role.
3) set the quota on the default tablespace to a unlimited or a reasonable max. In a
class environment, I would suggest a set size. Set the quota on all other tablepsaces
to none.
4) connected as the dba, import the export from the setup schema into the new schema
using the following command.
imp userid=dbauser/pass file=setup.exp ignore=y fromuser=setup touser= newuser
When you are done, you have an exact copy of the tables, indexes, sequences... that
were in the setup schema.
>>> [EMAIL PROTECTED] 05/07/01 09:26AM >>>
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 trainee has,
> the existing training database in Sybase used multiple
> databases to handle each trainee's transactions. To
> implement this in Oracle, we may need to create
> multiple schemas in one Oracle database, instead of
> creating multiple Oracle databases. Let's investigate
> the impact of having multiple schema in a database.
>
> Looks like Public synonym needs to be get rid off. Any
> other idea about the impact of having multiple schema?
>
> And is there an easy way to create a schema which is
> identical to another one?
>
> Thank you.
>
> Andrea
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Andrea Oracle
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> -----------------------------------------------------------
> This Mail has been checked for Viruses
> Attention: Encrypted Mails can NOT be checked !
>
> ***
>
> Diese Mail wurde auf Viren ueberprueft
> Hinweis: Verschluesselte Mails koennen NICHT geprueft werden!
> ------------------------------------------------------------
Hi,
I think that you're database won't work that well anymore if you try to
get rid of PUBLIC.
Why would you want to do that in the first place ?
--
Regards,
Stefan Jahnke
BOV AG
@:D2 Vodafone, Abt.: FIBM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jahnke
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
