Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help importing / exporting a schema
-----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.
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