Search found 1 match

by send2mohanraj
Tue Mar 12, 2013 4:36 am
Forum: Vertica Migration
Topic: migrating schema form oracle to vertica
Replies: 2
Views: 22893

Re: migrating schema form oracle to vertica

The below sql will help export the data from oracle tables. --use this to set the line size in sqlplus select sum( decode(data_type,'DATE',20,data_length )+ 1) from dba_tab_columns where table_name='&table_name'; --set the following in sqlplus set linesize <output from above> set pagesize 0 set head...

Go to advanced search