[imp] oracle_create script

[Hernan Morales]

Mensaje citado por: "Brent J. Nordquist" <bjn@horde.org>:

> OK, some questions for the Oracle users before I commit... recognizing
> that it's been a loo-o-ong time since I used Oracle :-)
> 
> (1)  If I commit this as oracle_create.sql, are users of Oracle before
> 8i
> going to have problems?  Should I commit this as oracle8i_create.sql,
> or
> will this work fine for both?
Really, I don't have oracle7 for testing but I "suposs" that it works for both
because the problem was in the active_sessions definition not in the oracle
version.

> 
> (2)  Compared to the old oracle_create.sql, this script removes PROMPT,
> SPOOL, and "/" as terminators -- I'll defer to your judgment on those. 
Yes, It doesn't matter. The terminators aren't necessary.
> 
> However, this one looks suspicious because there's no ";" terminator
> either:
> 
> > create index CHANGED on ACTIVE_SESSIONS (CHANGED asc)
You are right. The ";" terminator is missing. It must have the ";" at the end.

> 
> (3)  I think the following three fields need "NOT NULL" attributes,
> based
> on the old oracle_create.sql script, as well as the others (like
> MySQL):
> 
> > CREATE TABLE imp_addr (
> >     username varchar2(255),
> >     address varchar2(255),
> > [...]
> > CREATE TABLE imp_pref (
> >     username varchar2(255),
Yes, It needs "NOT NULL" at the end and to have clear all the things I think the
rest of the attributes must have the "NULL" statement.

Bye...


Hernan Morales
Servicios Internet
Almacenes La 14
Cali - Colombia
hernanm@la14.com