Re: Unextend a database


Roy Hann schreef:

> "Herman" <h.pool@xxxxxxxxx> wrote in message
> news:1137666550.465769.72960@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Hello all,
> >
> >
> > O.S. SunOS
> > Ingres: Ingres SPARC SOLARIS Version II 2.6/0305 (su4.us5/00)
> >
> > Is there a way to unextend a database?
>
> RTM about the extenddb utility and its -drop flag.
>
> Roy

Hi Roy,

The output of the command "extenddb -ldb40 ingahdnlp1 -drop" :

INGRES EXTENDDB Copyright 2003 Computer Associates Intl, Inc.
E_US18DC Unable to drop location `db40'.
This location is currently used by one or more databases,
as reflected by the iidatabase and/or iiextend catalogs.
You must destroy all databases that occupy a location
before that location can be dropped.
(Thu Jan 19 12:43:01 2006)

I am sure that the ingahdnlp1 database is the only database that is
extended to the db40 location.
I want to get rid of the location in the ingahdnlp1 database and after
that, I want to get rid of the db40 location at all.

regards,

.

Relevant Pages

  • Re: [Info-ingres] Re: Unextend a database
    ... and that the ingahdnlp1 database is the only database that is extended ... INGRES EXTENDDB Copyright 2003 Computer Associates Intl, ... I am sure that the ingahdnlp1 database is the only database that is ... extended to the db40 location. ...
    (comp.databases.ingres)
  • Re: defination in script
    ... "Roy" wrote in message ... > I am using Enterprise Manager and all tasks, Generate SQL Script. ... from one database to another via export/import data, ...
    (microsoft.public.sqlserver)
  • Re: CDatabase CRecordset - How to get the number of rows?
    ... The database ... David ... "Roy Fine" wrote: ... > return anything but ONE row with one scalar type. ...
    (microsoft.public.vc.mfc)
  • Re: Sed for Search and Replace
    ... > Roy Schestowitz wrote: ... >> it operates on files, not on a database, which is where all the data is ... I have extended these 'scripts' to ...
    (alt.html)
  • Re: qLocate Fails on Firebird DB after 1 hour of Inactivity
    ... Roy F wrote: ... any other Paradox specific construct against a CS database will only lead to problems. ... Not my experience in 15 or so years of running Pdox against InterBase servers. ...
    (comp.databases.paradox)