Sponsored Content
Full Discussion: Limit on a File size.
Top Forums Shell Programming and Scripting Limit on a File size. Post 302435803 by rajeshorpu on Thursday 8th of July 2010 08:22:32 AM
Old 07-08-2010
Limit on a File size.

Hi All,

I want to store 32KB of file in Oracle DB into CLOB field. I am not able to insert more than 32KB of file into CLOB. So i want to put a limit on the file size. I am using k shell.

My file size will dynamically increase its size, i want to check the file size if it is more than 32KB then put a limit and insert the same in CLOB field of DB.

Please help with sample script

Thanks,
Raj
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Limit size of the file

How do I limit size of a file to 1 MB or something like that under Linux? (4 Replies)
Discussion started by: _hp_
4 Replies

2. Solaris

File size limit

I want to have a permanent file created - and limit the size that this file can grow.. I want a circular file.. ie max size of file is 10 mb.. and if any new data written to file the oldest data removed.. How can I do this? I am on solaris 9 x86 (3 Replies)
Discussion started by: frustrated1
3 Replies

3. AIX

file size limit

Can anybody help me? How to increase file size limit in aix 5.2? I have already specified in /etc/security/limits file : default: fsize = -1 core = 2097151 cpu = -1 data = -1 rss = -1 stack = -1 nofiles = 2000 (2 Replies)
Discussion started by: vjm
2 Replies

4. Programming

File size limit exceeded

When i run my C program which dynamically creates the output file, the program stops after sometime and gives the error "File size limit exceeded" even though my working directory has space.Can anyone plz help me out. (13 Replies)
Discussion started by: drshah
13 Replies

5. UNIX for Advanced & Expert Users

File Size Limit

Hi, I have a problem writing or copying a file 2GB or larger to either the second or third disk on my C8000. I've searched this forum and found some good information on this but still nothing to solve the problem. I'm running hpux 11i, JFS3.3 and disk version 4 (from fstyp) on all 3 disks. ... (2 Replies)
Discussion started by: HaidoodFaulkauf
2 Replies

6. UNIX for Dummies Questions & Answers

Size limit for FTPing file

Is there any size limit for FTPing file from one unix system to another? (6 Replies)
Discussion started by: swarup2008
6 Replies

7. Shell Programming and Scripting

awk file size limit

My code is awk '{ out=split(FILENAME,a,"/") sub(/\./,"_",a) sub(/\-/,"_",a) NEWSTRING="main_"a"_"a"(" # The word we want to insert gsub(/main\(/,NEWSTRING); # the word to be replaced print "Main becomes ",NEWSTRING")","in file ",FILENAME >> "/home/ds2/test/NEW2.txt" ... (4 Replies)
Discussion started by: senior_ahmed
4 Replies

8. UNIX for Advanced & Expert Users

file size limit?

hi, how can I find out what the limit of a file size is on unix? thanks (6 Replies)
Discussion started by: JamesByars
6 Replies

9. Shell Programming and Scripting

sftp file size limit

Hi, Can some one please tell me the file size limit (if any) while using sftp I am trying to transfer a file ( size is almost 350 MB ) but it fails as shown below. sftp> put file1 ./file1 Uploading file1 to /dir1/./file1 file1 25% 100MB 10.2MB/s 00:28 ETA Couldn't write to remote... (6 Replies)
Discussion started by: vikash_k
6 Replies

10. HP-UX

2GB file size limit

Greetings, I'm attempting to dump a filesystem from a RHEL5 Linux server to a VXFS filesystem on an HP-UX server. The VXFS filesystem is large file enabled and I've confirmed that I can copy/scp a file >2GB to the filesystem. # fsadm -F vxfs /os_dumps largefiles # mkfs -F vxfs -m... (12 Replies)
Discussion started by: bkimura
12 Replies
CUBRID_LOB_SIZE(3)							 1							CUBRID_LOB_SIZE(3)

cubrid_lob_size - Get BLOB/CLOB data size

SYNOPSIS
string cubrid_lob_size (resource $lob_identifier) DESCRIPTION
cubrid_lob_size(3) is used to get BLOB/CLOB data size. PARAMETERS
o $lob_identifier -LOB identifier. RETURN VALUES
A string representing LOB data size, when process is successful. FALSE, when process is unsuccessful. CHANGELOG
+--------+-----------------------------------------------+ |Version | | | | | | | Description | | | | +--------+-----------------------------------------------+ | 8.4.0 | | | | | | | Change return value type from int to string. | | | | +--------+-----------------------------------------------+ EXAMPLES
Example #1 cubrid_lob_size(3) example <?php $lobs = cubrid_lob_get($con, "SELECT doc_content FROM doc WHERE doc_id=5"); echo "Doc size:".cubrid_lob_size($lobs[0]); cubrid_lob_export($conn, $lobs[0], "doc_5.txt"); cubrid_lob_close($lobs); ?> SEE ALSO
cubrid_lob_get(3), cubrid_lob_close(3), cubrid_lob_export(3), cubrid_lob_send(3). PHP Documentation Group CUBRID_LOB_SIZE(3)
All times are GMT -4. The time now is 07:07 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy