Search
⌘K
Podcast
About Calvin
Back
Log in
Theme
Auto
Light
Dark
Podcast
a
About Calvin
Back
Oracle Setup Statements
Other
·
Calvin Correli
·
Mar 31, 2002
·
1
minutes
Project name:
DB Password:
Oracle data path:
First, Connect
$ svrmgrl $ connect internal
Alternatively:
$ sqlplus sys/<i>password</i>
Create Tablespace
create tablespace myproject datafile ’/ora8/m02/oradata/ora8/myproject01.dbf’ size 50m autoextend on next 640k maxsize 2147450880 extent management local uniform size 160K;
Create User
create user myproject identified by myproject_pwd default tablespace myproject temporary tablespace temp quota unlimited on myproject; grant connect, resource, ctxapp, javasyspriv, query rewrite to myproject; revoke unlimited tablespace from myproject; alter user myproject quota unlimited on myproject;
Drop User
drop user myproject cascade;
Previous
Handy tool for installing OpenACS on Oracle
Next
Sharing knowledge, sharing code
Like
Comments
Newest
Back
Newest
Oldest
Top
Name
Email
Back
URL
Back
Youtube, Loom, Rumble or Vimeo URL
Back
Search
Write a comment...
Name
Email
Back
URL
Back
Youtube, Loom, Rumble or Vimeo URL
Back
Search
Copyright © 2025 Calvin Correli
powered by
___MESSAGE___
___MESSAGE___
Comments