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
LEARN ABOUT PHP
fbsql_read_clob
FBSQL_READ_CLOB(3) 1 FBSQL_READ_CLOB(3)
fbsql_read_clob - Read a CLOB from the database
SYNOPSIS
string fbsql_read_clob (string $clob_handle, [resource $link_identifier])
DESCRIPTION
Reads CLOB data from the database.
If a select statement contains BLOB and/or CLOB columns FrontBase will return the data directly when data is fetched. This default behav-
ior can be changed with fbsql_set_lob_mode(3) so the fetch functions will return handles to BLOB and CLOB data. If a handle is fetched a
user must call fbsql_read_clob(3) to get the actual CLOB data from the database.
PARAMETERS
o $clob_handle
- A CLOB handle, returned by fbsql_create_clob(3).
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
Returns a string containing the specified CLOB data.
EXAMPLES
Example #1
fbsql_read_clob(3) example
<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
or die("Could not connect");
$sql = "SELECT CLOB_COLUMN FROM CLOB_TABLE;";
$rs = fbsql_query($sql, $link);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain the clob data for the first row
fbsql_free_result($rs);
$rs = fbsql_query($sql, $link);
fbsql_set_lob_mode($rs, FBSQL_LOB_HANDLE);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain a handle to the CLOB data in the first row
$clob_data = fbsql_read_clob($row_data[0]);
fbsql_free_result($rs);
?>
SEE ALSO
fbsql_create_clob(3), fbsql_read_blob(3), fbsql_set_lob_mode(3).
PHP Documentation Group FBSQL_READ_CLOB(3)