Re: Oracle 9i on Windows Server 2003 64 bit

aaa_at_bbb.com wrote:

>Hi,
>
>I have Oracle 9i (9.2.0.2.0) 64 bit installed on an Itanium server
>running Windows Enterprise Server 2003 64 bit, and I am having trouble
>creating the tables, views etc for a database.
>
>The 64 bit version of Oracle does *not* include the Enterprise Server
>Manager. The documentation that comes with Oracle says that you need
>to use the 32 bit version from a different machine, remotely. I do not
>have another machine set up with Oracle 32 bit. (BTW, it also does not
>include the security manager)
>
>The only means I have to create a database is by using the Database
>Configuration Assistant. This has an option to run scripts as part of
>the creation process, so I added several "*.sql" files that contain
>create table statements, but whilst these were in fact run, everything
>within them failed. So the end result is a database containing only
>the Oracle system tables, with no application tables.
>
>The sql files have been run successfully on a Solaris server, so the
>syntax is correct.
>
>I have found documenation on the web that says to create a table, just
>open a Windows command window and run "svrmgr filename.sql" (as well
>as a few other steps), but the 64 bit version of Oracle does not
>include this program. I have searched my whole hard disk for
>"svrmgr*.*" with no result.
>
>If anyone can suggest a method that I can use to create the tables,
>views etc., I would be very appreciative.
>
>Thanks,
>Dave
>
>

What exactly is wrong with SQL*Plus and iSQL*Plus?

Try this syntax:

SQL> CREATE TABLE test (test VARCHAR2(20));

Then:

SQL> desc test

I know it may be amazing in this age of GUI's but it works. What will they think of next. ;-)

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)