12-30-2008
Quote:
Originally Posted by
FlyingSquirrel
Open the file in "vi"
:1,$s/SIZE X .*$/SIZE 100M/
Hi FlyingSquirrel,
Thanks a lot for all the help.
Attached are the 2 files mentioned below:
create_tablespaces.sql has the original file.
ram_test_tbs.sql has the output from the code provided by you.
If I look at the output file not all the tablespace creation scripts have been changed. Could you please help me figure out what I have done wrong in my original file create_tablespaces.sql ?
Thanks,
Ram.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need to execute a script to find the tablespace size in oracle.But i get an error.:confused:
Script Executed:-
#!/bin/ksh
ORACLE_SID= oracelinstance
ORACLE_HOME= oracle path
PATH=$ORACLE_HOME/bin
export ORACLE_SID ORACLE_HOME PATH
sqlplus... (4 Replies)
Discussion started by: vighna
4 Replies
2. Shell Programming and Scripting
Hi ,
I am trying to run this script in crontab but I get errors. When I run it explicitly like ./monitor_tblsp from another location then it runs fine . I am messing somewhere with paths but I don't know where and how . Please help .
Here is the error part
./monitor_tblsp: touch: not... (2 Replies)
Discussion started by: capri_drm
2 Replies
3. Shell Programming and Scripting
Hi,
Can some one tell me if we can configure the jobs in crontab using a shell script.
I know it can be done easily by using "crontab -e", but i just want to know whether we can add a job into the crontab using a shell script.
If it can be done, plz suggest the procedure to do it.
If it... (6 Replies)
Discussion started by: rudrarajumk
6 Replies
4. Shell Programming and Scripting
I have developed the following shell script. The idea was to create an alias to execute it and return the tablespaces and their sizes from an oracle database. When I execute is via the alias, I have issues.
So, here is the script first:
> cat ts_size.sh
#!/bin/ksh
xwhere=" "
xwild=" "... (8 Replies)
Discussion started by: desibabu
8 Replies
5. Shell Programming and Scripting
I have prepared the below script to monitor the tablespace and alert the users whenever it reaches a threshold limit.
#!/bin/sh
. /home/.profile
sqlplus -s $LOGON << .eof > $scripts/check_tablespace.temp
set pages 0
select tablespace_name, free_percent
from (
SELECT... (4 Replies)
Discussion started by: svajhala
4 Replies
6. Shell Programming and Scripting
Hello,
I have a big file in wich I would like to rename inside this exactly the string '_ME' and not rename in case we have 'ABC_MELANGE'. Is there a way to do it by using a shell script?
Any tip will be apreciated.
The file is like described bellow, after using command more filename :
... (3 Replies)
Discussion started by: Titas
3 Replies
7. Shell Programming and Scripting
i have a file called number which contains data as
1 2 3 4 5
6 7 8 9 0
9 8 7 6 5
4 3 2 1 0
0 1 2 3 4
needed a shell script to print the output as
1
7
7
1
4
and (2 Replies)
Discussion started by: jacky29
2 Replies
8. Shell Programming and Scripting
I'm new to unix script, and I need to check the tablespaces daily, here is the script(quite simple), but it does not work. Did I missed something ?
Please guide me, Many thanks !
#!/bin/sh
echo "ORA TABLEASPACE:"
sqlplus system/oracle as sysdba;
set pagesize 9999;
set linesize 132;
... (5 Replies)
Discussion started by: dehetoxic
5 Replies
9. UNIX for Dummies Questions & Answers
hi
can any one help me in shell scripting
where in my requirement is to
write a shell script where in if i run that script i should copy all the .doc files from one system to another systems within a network like from parent folders to child folder
example
parent folder A within parent folder... (5 Replies)
Discussion started by: afra
5 Replies
10. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
I am trying to automate hadoop installation procedure using shell script. It involves go to perticular directory... (3 Replies)
Discussion started by: Abdul Navaz
3 Replies
LEARN ABOUT PHP
fbsql_read_blob
FBSQL_READ_BLOB(3) 1 FBSQL_READ_BLOB(3)
fbsql_read_blob - Read a BLOB from the database
SYNOPSIS
string fbsql_read_blob (string $blob_handle, [resource $link_identifier])
DESCRIPTION
Reads BLOB 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_blob(3) to get the actual BLOB data from the database.
PARAMETERS
o $blob_handle
- A BLOB handle, returned by fbsql_create_blob(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 BLOB data.
EXAMPLES
Example #1
fbsql_read_blob(3) example
<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
or die("Could not connect");
$sql = "SELECT BLOB_COLUMN FROM BLOB_TABLE;";
$rs = fbsql_query($sql, $link);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain the blob 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 BLOB data in the first row
$blob_data = fbsql_read_blob($row_data[0]);
fbsql_free_result($rs);
?>
SEE ALSO
fbsql_create_blob(3), fbsql_read_clob(3), fbsql_set_lob_mode(3).
PHP Documentation Group FBSQL_READ_BLOB(3)