Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Single sql query to spool to multiple files
Top Forums Programming Single sql query to spool to multiple files Post 302269323 by jim mcnamara on Wednesday 17th of December 2008 11:31:08 AM
Old 12-17-2008
What OS are you on - does it not support "largefiles" -- files larger than what a 32 bit file pointer can reference offsets for? If this is the case you WILL have to resort to PL/SQL and UTL_FILE calls to open and close files. Note that most installations of Oracle control the "allowed" directories for utl_file to work against. So if you are creating a bunch of monster files, you script had better check free disk space on that filesystem first.

Code:
select value from v$parameter where name like '%utl_file_dir%';

gives you the name of the filesystem. Or ask your dba.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To spool output from a database query

Hi all, I would want to spool file for a database query, however by using crontab, the file is not spooled. Below shows my script: ORACLE_HOME="/u01/oraprod/perpdb/10.1.0/db_1" OUTFILE="/tmp/invalid.out" FILE="$HOME/admin/scripts" $ORACLE_HOME/bin/sqlplus -s "/as sysdba"... (0 Replies)
Discussion started by: *Jess*
0 Replies

2. Shell Programming and Scripting

Executing Multiple .SQL Files from Single Shell Script file

Hi, Please help me out. I have around 700 sql files to execute in a defined order, how can i do it from shell script (3 Replies)
Discussion started by: anushilrai
3 Replies

3. UNIX for Dummies Questions & Answers

split a single sql file into multiple files

Hi,I have a single sql file containing many create table ddl's.Example: CREATE TABLE sec_afs ( rpt_per_typ_c char(1) NOT NULL, rpt_per_typ_t varchar(20) NULL, LOCK ALLPAGES go EXEC sp_primarykey 'sec_afs', rpt_per_typ_c go GRANT SELECT ON sec_afs TO developer_read_only... (5 Replies)
Discussion started by: smarter_aries
5 Replies

4. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies

5. UNIX for Dummies Questions & Answers

Grep multiple strings in multiple files using single command

Hi, I will use below command for grep single string ("osuser" is search string) ex: find . -type f | xarg grep -il osuser but i have one more string "v$session" here i want to grep in which file these two strings are present. any help is appreciated, Thanks in advance. Gagan (2 Replies)
Discussion started by: gagan4599
2 Replies

6. Shell Programming and Scripting

SQL query in a loop with single sqlplus connection

Hi, I'm trying to build a shell script that reads a set of accounts from a file. For each account I need to perform a set of sql queries. So I have a loop with a set of sqlplus connections to retrieved my data. Is it possible to have a single sqlplus connection before entering the loop and... (4 Replies)
Discussion started by: lsantacana
4 Replies

7. Shell Programming and Scripting

UNIX/SQL loop to spool files!!

I want to spool files from unix using a sql script that would take values from another sql query within the KSH script.. unix loop select order_date from date_tbl for each order_Date i need to call this spool script with the value sqlplus scott/tiger@order_db @/ordspool/order_date.sql... (2 Replies)
Discussion started by: vr23
2 Replies

8. Shell Programming and Scripting

SQL*PLUS Spool Output

Hi, Im writing a script to run a bit of sql(via sqlplus) that pulls back some data and spools it to a file, I want the spool file to only display the data, with no sql command at the top and no reports at the bottom ie(# of records recieved). I am currently doing it via a grep command but... (1 Reply)
Discussion started by: Magezy
1 Replies

9. UNIX for Dummies Questions & Answers

To pass multiple arguments from file in to an sql query

Hi all , I want to pass contents from a file say f1 as arguments to a sql query which has In statement using a script example select * from table_1 where login in ( `cat f1`) ; will this work or is there any other way to do it. (1 Reply)
Discussion started by: zozoo
1 Replies

10. Shell Programming and Scripting

Create Multiple UNIX Files for Multiple SQL Rows output

Dear All, I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File. The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files. Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies

LEARN ABOUT OPENSOLARIS

xfs_freeze

xfs_freeze(8)						      System Manager's Manual						     xfs_freeze(8)

NAME

       xfs_freeze - suspend access to an XFS filesystem

SYNOPSIS

       xfs_freeze -f | -u mount-point

DESCRIPTION

       xfs_freeze suspends and resumes access to an XFS filesystem (see xfs(5)).

       xfs_freeze  halts  new access to the filesystem and creates a stable image on disk.  xfs_freeze is intended to be used with volume managers
       and hardware RAID devices that support the creation of snapshots.

       The mount-point argument is the pathname of the directory where the filesystem is mounted.  The filesystem must be  mounted  to	be  frozen
       (see mount(8)).

       The  -f flag requests the specified XFS filesystem to be frozen from new modifications.	When this is selected, all ongoing transactions in
       the filesystem are allowed to complete, new write system calls are halted, other calls which modify the	filesystem  are  halted,  and  all
       dirty data, metadata, and log information are written to disk.  Any process attempting to write to the frozen filesystem will block waiting
       for the filesystem to be unfrozen.

       Note that even after freezing, the on-disk filesystem can contain information on files that are still in the process of	unlinking.   These
       files will not be unlinked until the filesystem is unfrozen or a clean mount of the snapshot is complete.

       The  -u	flag  is used to un-freeze the filesystem and allow operations to continue.  Any filesystem modifications that were blocked by the
       freeze are unblocked and allowed to complete.

       One of -f or -u must be supplied to xfs_freeze.

NOTES

       A copy of a frozen XFS filesystem will usually have the same universally unique identifier (UUID) as the original, and  thus  may  be  pre-
       vented from being mounted.  The XFS nouuid mount option can be used to circumvent this issue.

       In  Linux  kernel version 2.6.29, the interface which XFS uses to freeze and unfreeze was elevated to the VFS, so that this tool can now be
       used on many other Linux filesystems.

SEE ALSO

       xfs(5), lvm(8), mount(8).

																     xfs_freeze(8)
All times are GMT -4. The time now is 07:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy