Search found 3 matches

by info4km
Mon Dec 07, 2015 2:53 pm
Forum: Vertica Installation
Topic: Receiving "These disks do not have known IO schedulers" installing 7.2 on CentOS 6
Replies: 1
Views: 15799

Receiving "These disks do not have known IO schedulers" installing 7.2 on CentOS 6

Hi I am running the install_vertica script and it doesn't get past the checking. I am receiving the following errors/warnings. Note that I've already adjusted the scheduler for sda to deadline. I checked the mapping of these lv partitions and I see they are dm-0 and dm-2. The only scheduler mentione...
by info4km
Tue Oct 20, 2015 2:32 pm
Forum: Vertica Migration
Topic: how to create sql for constraints when migrating from oracle
Replies: 2
Views: 22051

Re: how to create sql for constraints when migrating from oracle

I have seen this already, thanks. We already have the tables, and were hoping to create the constraints all at once some how. Maybe we will need to rethink this and use the ddl to try and create the tables with the constraints at the same time. I did try to use the get_ddl metadata functions to crea...
by info4km
Mon Oct 19, 2015 7:52 pm
Forum: Vertica Migration
Topic: how to create sql for constraints when migrating from oracle
Replies: 2
Views: 22051

how to create sql for constraints when migrating from oracle

We are migrating from Oracle to Vertica. We have all of the tables created. Is there an easy way to generate generic/vertica compatible DDL/sql alter commands to add the constraints to the new Vertica DB? Maybe from the all_constraints data. Could oracle dbms_metadata.get_ddl be used to generate com...

Go to advanced search