Re: Help deleting a database
Posted in 1999
DROP DATABASE dbname
ex: DROP DATABSE stores7 (<-- that's from the book!)
Or the full pathname in quotes :
DROP DATABASE '/u/training/stores7'
Patrice.
Keith R. Kearnan <Keith_Kearnan@dfci.harvard.edu> wrote in message
news:382A78B3.E13A7881@dfci.harvard.edu...
> Hi,
>
> I'm a total Informix novice, I have been asked to move our production
> database to our test system. The dbexport went well from the production
> box but I can't dbimport it into our test box because of the following
> error:
>
> 330 - Cannot create database.
>
> 100 - ISAM error: duplicate value for a record with unique key.
>
> I have no clue how to remove the existing test database and the doc set
> is at my other office accross the city. I think the version of Informix
> is 5.08.
>
> -Thanks in advance
>
> -Keith Kearnan
> mailto:Keith_Kearnan@dfci.harvard.edu
>