Oracle Setup Statements

Other
Mar 31, 2002
by Calvin Correli
1 min read
Project name:
DB Password:
Oracle data path:




First, Connect



$ svrmgrl
$ connect internal


Alternatively:



$ sqlplus sys/<i>password</i>




Create Tablespace






Create User






Drop User






Like

About Calvin Correli

I've spent the last 17 years learning, growing, healing, and discovering who I truly am, so that I'm now living every day aligned with my life's purpose.

Read more
Read next

Handy tool for installing OpenACS on Oracle

6 comments

Malte Sussdorff
 

Change in the tablespace create statement You might want to change to locally managed tablespaces and include a maxsize for Linux as well. <p> <code>create tablespace service_name datafile '/ora8/m02/oradata/ora8/service_name01.dbf' size 50m autoextend on next 640k maxsize 2147450880 extent management local uniform size 160K;</code>
Read more
Read less
Reply over 22 years ago
  Cancel
Lars Pind
 

Done Thanks.
Read more
Read less
Reply over 22 years ago
  Cancel
Durgarao Sabbineni
 

how to Create the new database and new tablespace and new user? Please help me.
Read more
Read less
Reply over 22 years ago
  Cancel
Lars Pind
 

Have you tried the installation guide? http://openacs.org/doc/openacs-4/openacs.html
Read more
Read less
Reply over 22 years ago
  Cancel
Jeff Davis
 

dba_data_files A quick way to find out where oracle is putting its data files is to ask the server... <pre> svrmgrl connect internal select * from dba_data_files; </pre>
Read more
Read less
Reply over 22 years ago
  Cancel
arief zj
 

Oracle 9i Is there a new oracle driver for oracle 9i ??
Read more
Read less
Reply over 22 years ago
  Cancel

Leave a comment