Database Administration (MOSC)

MOSC Banner

spooling a CLOB data

edited Nov 3, 2010 5:49PM in Database Administration (MOSC) 3 commentsAnswered
 Hello. I have a table in 10.2.0.3 database with a long varchar2 column and a CLOB column

The app team needs to download this table into a file. The file is to be massaged and loaded into another database (oracle or teradata). The  app team is using the following command to create a file

select column1 || ',' || column2 || ',' ... from table

This is spooled into a flat file. The issue is that one table record does not fit into one line in the file. In a quick test that I did the number of rows was 9 and the number of records in the file was 32. Is there a way to make each output row from the table to 'fit' one row in the output file?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center