CMap - oracle dumps of Gramene maps?

[Ken Youens-Clark]

On Mar 29, 2005, at 11:14 AM, Gregory Brown wrote:

> I was able to get CMap version .13 running using mysql on a mac g5 osX 
> system.  I found the mysql dumps for the Gramene CMap maps and loaded 
> those successfully.  Now I would like to switch my CMap database to 
> Oracle (version 10g) and load the Gramene CMap data.  Unfortunately I 
> cannot find any oracle dump files on the gramene ftp site.  I have 
> found the tab separated gramene CMap data.  I need advice on how to 
> actually load this CMap data into an oracle db.

When you say the tab-delimited CMap data, do you mean the files that 
are named by the map sets, or are there tab files that are named like 
table names (e.g., "cmap_feature")?  If not the latter, then I would 
say we need to be dumping tab-delimited files of every table in our 
databases for loading with MySQL's "mysqlimport" or the LOAD FILE 
command (which is much faster to use than parsing the default CREATE 
and INSERT statements from "mysqldump").  Additionally, it would 
probably make it easier for non-MySQL users to import given simple 
things like how MySQL and Oracle each escape embedded quotes, etc.

Shuly or Greg, Oracle can import tab files if the fielded data is in 
the same order as the column definitions in the table, right?

ky