<No Subject Supplied>

>From naomi Tue Jun 1 15:53:44 MST 1993 remote from qip From: naomi@qip (Naomi Walker) Message-Id: <9306012253.AA28568@qip> Received: from qip by misty.anasazi.com; Tue, 1 Jun 93 15:53:46 MST Received: by qip (5.61/1.2) (from naomi (Naomi Walker) to informix-list@rmy.emory.edu) id AA28568; Tue, 1 Jun 93 15:53:45 -0700 Subject: dbspace information To: informix-list@rmy.emory.edu (Informix List) Date: Tue, 1 Jun 93 15:53:44 MST X-Mailer: ELM [version 2.3 PL11] Content-Type: text Content-Length: 728 Can anyone tell me how to get the dbspace information for an entire database, or any of its tables? I need to be able to drop a table and recreate it; with lock modes, extents, and dbspaces intact. For the time being, my databases typically reside in one dbspace or another. Our huge-r systems have some critical tables in dbspaces of their own, for performance reasons. Once we can restore a particular dbspace from an archive, I expect to scatter tables among dbspaces on a regular basis. Anyone know? -- Naomi Walker (aka N7FSA) naomi@anasazi.com Phoenix, Arizona To get the full value of joy, you must have someone to divide it with. ---Mark Twain