04-29-2003
Please execute the statement
alter database open at the sql*plus prompt.
and report the error message
Donot try to run the scripts before opening
Rgds
10 More Discussions You Might Find Interesting
1. Filesystems, Disks and Memory
i want to know, how do i to create a rwa partttions in unixware 7
wit raid 5
best regards
felix arteaga (1 Reply)
Discussion started by: farteaga
1 Replies
2. UNIX for Advanced & Expert Users
I have been tasked with archiving Oracle tables. The data is on raw devices, and possibly will span multiple logical volumes.
Has anyone ever had to do this? How did you accomplish it?
Any references to accomplish this would be greatly appreciated.
Thanks, (2 Replies)
Discussion started by: isenhart
2 Replies
3. Solaris
Hi all,
I would like to know how to make new partitions....
I currently have allocated 60G for various slices (I have totally used 4 out of 7 available slices...
I am running only solaris on my box.
My plan is to have entire disk dedicated to solaris and run other OS from within... (19 Replies)
Discussion started by: wrapster
19 Replies
4. UNIX and Linux Applications
Hi everyone,
So far, I have done all the steps (including creating django.wsgi in the project). The step left is to turn on the httpd, but error put exit in this very last step. :(
<user> #: ./apachetrl start
httpd: Syntax error on line 450 of /usr/local/apache2/conf/httpd.conf:
Cannot... (1 Reply)
Discussion started by: AlexCheung
1 Replies
5. Web Development
Hi everyone,
So far, I have done all the steps (including creating django.wsgi in the project). The step left is to turn on the httpd, but error put exit in this very last step.:(
<user> #: ./apachetrl start
httpd: Syntax error on line 450 of /usr/local/apache2/conf/httpd.conf:
Cannot load... (1 Reply)
Discussion started by: AlexCheung
1 Replies
6. AIX
Please consider this a question about basics&best practices. On AIX 5.3 system, three raw physical volumes are defined from storage. While doing a read with command dd from the raw device, the speed rate is 250Mb/s.
Then, it gets complex when I define these three pv's to an lv of type raw. Doing... (4 Replies)
Discussion started by: royalliege
4 Replies
7. AIX
Hellow friends,
We are having AIX 5.3 total memory allotted to /Backup directory is 700GB actual used memory is 250GB ..but when i issue df -gt command to check space it is showing /Backup directory is 70% full ..how to identify root cause.? (1 Reply)
Discussion started by: umashankar1987
1 Replies
8. UNIX for Dummies Questions & Answers
Oracle Linux 6.6
To create Physical Volumes for Volume groups (LVM) , the disk need to be partitioned to LVM type ie. 'Linux LVM' type . In fdisk , this can done by choosing 8e when prompted for partition type.
Since it is easy to script (non-interactive), I use parted command rather than... (1 Reply)
Discussion started by: John K
1 Replies
9. Solaris
I am using Solaris 9 (Sparc based) with Sybase and a proprietary DB application that works with Sybase. In the past we have not used SVM or any RAID config. The DBs were configured such that each DB had its own partition.
Now I would like to setup a new machine with the DBs on a RAID5 config... (1 Reply)
Discussion started by: DavidC_SysEngr
1 Replies
10. Ubuntu
I am running Ubuntu 16.04 on a HP laptop with a core I3 processor. I am trying to run mariaDB and do hot backups to disk. In order to do that I wanted to create an LVM snapshot and backup the snapshot for a point in time backup, possibly using tar. I included a snapshot of the gparted app showing... (1 Reply)
Discussion started by: gandolf989
1 Replies
EXECUTE(7) SQL Commands EXECUTE(7)
NAME
EXECUTE - execute a prepared statement
SYNOPSIS
EXECUTE name [ ( parameter [, ...] ) ]
DESCRIPTION
EXECUTE is used to execute a previously prepared statement. Since prepared statements only exist for the duration of a session, the pre-
pared statement must have been created by a PREPARE statement executed earlier in the current session.
If the PREPARE statement that created the statement specified some parameters, a compatible set of parameters must be passed to the EXECUTE
statement, or else an error is raised. Note that (unlike functions) prepared statements are not overloaded based on the type or number of
their parameters; the name of a prepared statement must be unique within a database session.
For more information on the creation and usage of prepared statements, see PREPARE [prepare(7)].
PARAMETERS
name The name of the prepared statement to execute.
parameter
The actual value of a parameter to the prepared statement. This must be an expression yielding a value that is compatible with the
data type of this parameter, as was determined when the prepared statement was created.
OUTPUTS
The command tag returned by EXECUTE is that of the prepared statement, and not EXECUTE.
EXAMPLES
Examples are given in the Examples [prepare(7)] section of the PREPARE [prepare(7)] documentation.
COMPATIBILITY
The SQL standard includes an EXECUTE statement, but it is only for use in embedded SQL. This version of the EXECUTE statement also uses a
somewhat different syntax.
SEE ALSO
DEALLOCATE [deallocate(7)], PREPARE [prepare(7)]
SQL - Language Statements 2010-05-14 EXECUTE(7)