∕
Search or ask a question
⌘K
About Calvin
Podcast
We Can Do This Book
Speaking
Back
Log in
Theme
Auto
Light
Dark
a
About Calvin
Podcast
w
We Can Do This Book
s
Speaking
Back
Oracle Setup Statements
Other
·
Calvin Correli
·
Mar 31, 2002
·
1 minute
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
cancel
Back
Youtube, Loom, Rumble or Vimeo URL
Back
Search
Write a comment...
Name
Email
Back
URL
cancel
Back
Youtube, Loom, Rumble or Vimeo URL
Back
Search
228 Park Ave S
PMB 92530
New York, NY 10003
United States
Copyright © 2025 Calvin Correli
powered by
___MESSAGE___
___MESSAGE___
Comments