Search found 1 match
- Tue Mar 12, 2013 4:36 am
- Forum: Vertica Migration
- Topic: migrating schema form oracle to vertica
- Replies: 2
- Views: 23452
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...