Ingres to Oracle table
Date: 1995/10/05
Message-ID: <451c3p$cnd_at_nntp.interaccess.com>#1/1
Hi netters,
I have a relatively simple question for people who have worked on
Ingres as well as oracle.
I know how to create tables in Oracle.
Ingres table sample layout that I have:
Cloumn Information:
I would like to create table 'text' from the following information:
(actually, I have about 20 or so more tables to create.)
Name: text
Owner: ingres
Created: 05-jan-1994 17:00:01
Type: user talble
Version: ING6.0
Row width: 75
Number of Rows: 200
Storage structure: btree
Compression: none
Duplicate Rows: not allowed
Number of pages: 50
Overflow data pages: 0
Journaling: diabled
Base table for view: no
Permissions: yes, including SELECT to ALL
Integities: none
Optimizer statistics: none
Key
Column Name Type Length Nulls Defaults Seq
name character 15 no yes 2
zpa integer 25 no yes 1
zpb integer 25 no yes 3
zpc integer 25 no yes
zpd integer 25 no yes
Please post replies on the net with possible brief explanation.
Thanks,
Sapan.
Received on Thu Oct 05 1995 - 00:00:00 CET