Rdb on OpenVMS, IBM zSeries and Oracle on OpenVMS (MOSC)

MOSC Banner

OVMS: RMS file on open VMS and Oracle External Tables

edited Jun 5, 2014 12:00PM in Rdb on OpenVMS, IBM zSeries and Oracle on OpenVMS (MOSC) 4 commentsAnswered

Hi

We have RMS database that resides on VMS. We were wondering if it would be possible for us to copy the *.dat files (RMS data files) and then create a directory and then read that file using Oracle External Table feature and then load it into heap table using insert into heap table select * from external table

would it be possible to do this? Any caveats?

Thanks

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