∕
Search
⌘K
About Calvin
Podcast
We Can Do This Book
Speaking
Back
No matching results found.
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
Comments
Newest
Back
No matching results found.
Newest
Oldest
Top
Write a comment...
Name
Email
cancel
Name
Email
cancel
Back
YouTube, Loom, Rumble, Vimeo or Spotify URL
Back
Search
Post
1 Chestnut Hill Plaza #1139
Newark, DE 19713
United States
Copyright © 2026 Calvin Correli
powered by
___MESSAGE___
___MESSAGE___
Cancel
Submit
Cancel
OK
Comments