Database Administration (MOSC)

MOSC Banner

How extract LONG RAW data and move to another database?

edited Sep 7, 2023 7:07AM in Database Administration (MOSC) 2 commentsAnswered ✓

Hello,

The database version is 12c.

There is a table with column data type is LONG RAW. And I have a plan to develop a script for converting to BLOB. But I want to move some sample of data from this table to other database for testing. The DBA support to extract some records to insert script, then I can use the insert script to insert to local database for testing. But I have faced the error:

ORA-01704: string literal too long.

I see the content of LONG RAW columns is so long.

Do we have some solution to move some sample data to other database?

Tagged:

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