Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help importing / exporting a schema

Re: Need help importing / exporting a schema

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 04 Jun 2007 20:48:04 +0200
Message-ID: <f41rnv$9u3$1@news4.zwoll1.ov.home.nl>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Blake McBride wrote:
> Thank you so much for a straight forward answer to my questions.
>
> Your answers are just what I was looking for. I do have one follow up
> question
> if you will be so kind. You said:
>

>> A "Database" is not the same in Oracle - in Oracle speak, you drop
>> a schema. As a schema is connected to a user, "drop user abc cascade;"
>> will do the trick, as long as you are logged on with a priveleged
>> account,
>> such as system.

>
>
> Once I drop the user, I'd like the command needed to immediately re-create
> the
> user (with a blank database). This way I can just run my SQL script to
> re-create the tables, etc.
>

As I said - "database" is NOT to be compared with Sybase or MS SS200x.

You can create a use by issuing:
create use whatever identified by secret default tablespace users
temporary tablespace temp;
(Forgot the version you're working in - the latest *knows* what the system wide defaults are, so "create user...identified by..." is sufficient - but the syntax is correct for any version)

You then grant your newly created user whatever is needed - the possibility to connect would be a nice one: grant create session to whatever;

And that continues:
grant create table, create index, create .... to whatever;

That will do.

Make sure your user can store objects:
alter user whatever quota unlimited on users;

In case you have your indexes stored elsewhere: alter user whatever quota unlimited on users quota unlimited on index_tablespace;

More on that in the DBA guide on tahiti.oracle.com - --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGZF5kLw8L4IAs830RAmnDAJ9a+aTqx5AUUdBlbmY+vFfyoKfW8wCffl4C 2ZKjNghf91YkYW4DYZ11kGA=
=+g9I
-----END PGP SIGNATURE----- Received on Mon Jun 04 2007 - 13:48:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US