sql_servers oracle -- : open source web directory

return to: http:/www.sirfsup.com /sql_servers /oracle

sub-categories and articles

forms

add

pl_sql

add

--->create new sub-category

alter.htm

add

alter database

ALTER DATABASE db_name ADD LOGFILE MEMBER 'file specification' REUSE TO GROUP n;
ALTER DATABASE db_name ADD LOGFILE MEMBER 'file specification' REUSE TO ('file_specification', 'file_specification') ;
ALTER DATABASE tablespace RENAME FILE 'old name' TO 'new name';

changelog.txt

add

Mon Jan 6 04:48:14 CST 2003 first: double-checked all memory parameters from /etc/rc.d/rc.local ran dbca as the 'oracle' user instance successfully created and initialized

connect.htm

add

sqlplus: SQLPLUS username/password@connect_string @command_file
SVRMGR: connecting to SRVMGR SRVMGR: the following are issued after connecting to SVRMGR: connect username[@dbalias]

create

add

<h3><a name="intr"></a>introduction</h3> <dl> <dd>CREATE object_type object_name <dd>create options <dd>STORAGE (storage parameters)

create.htm

add

introduction

CREATE object_type object_name

create options

STORAGE (storage parameters)

drop.htm

add

drop database db;: *; ERROR at line 1:

formatting.htm

add

formatting:

rpad and lpad

formatting.txt

add

formatting:

rpad and lpad

hs_err_pid1694.log

add

An unexpected exception has been detected in native code outside the VM. Unexpected Signal : 7 occurred at PC=0x4054066B Function=(null)+0x4054066B Library=/home/java/j2sdk1.4.0/jre/lib/i386/libzip.so NOTE: We are unable to locate the function name symbol for the error

linux_db_install.htm

add

9i for linux

downloading the 3 *.cpio.gz files, unzipping them in /tmp. from there, following instructions in the documentation. RH 8.0

the 3 *.cpio.gz files consumed about 1.8G of space; the installation took 3.5G out of my home directory. I have /home on a 5G partition and /tmp on another 5G partition, with 20G to the disk.

apparently selecting the defaults in dbca will create a database over 1.75 Gb in size. how I know is that when trying to create a second one it said I didn't have enough space, and I had 1.3GB.

linux_forms_install.htm

add