0

Oracle Setup Statements

Project name:
DB Password:
Oracle data path:




First, Connect



$ svrmgrl
$ connect internal


Alternatively:



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




Create Tablespace






Create User






Drop User






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
  Cancel
Done Thanks.
Read more
Read less
  Cancel
Durgarao Sabbineni

how to Create the new database and new tablespace and new user? Please help me.
Read more
Read less
  Cancel
Have you tried the installation guide? http://openacs.org/doc/openacs-4/openacs.html
Read more
Read less
  Cancel
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
  Cancel
Oracle 9i Is there a new oracle driver for oracle 9i ??
Read more
Read less
  Cancel

Leave a comment