Where are these tables??
<FONT face="Default Sans Serif, Verdana, Arial, Helvetica, sans-serif" size=2><DIV> </DIV><DIV><DIV>While trying to find the physical disk space size each table in our database (by matching the file name in the base directory to an entry in pg_class), we found 4 files that constitute 5gigs that we cannot match back to a entry in pg_class.</DIV><DIV>Is it safe to delete these? </DIV><DIV> </DIV><DIV>TIA<br>Patrick Hatcher<br></DIV></DIV></FONT>
From pgsql-general-owner@postgresql.org Fri Mar 26 10:43:49 2004
X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
by svr1.postgresql.org (Postfix) with ESMTP id A11EFD1BA68
for <pgsql-general-postgresql.org@localhost.postgresql.org>; Fri, 19 Mar 2004 11:24:14 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
with ESMTP id 53712-01
for <pgsql-general-postgresql.org@localhost.postgresql.org>;
Fri, 19 Mar 2004 07:24:15 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
by svr1.postgresql.org (Postfix) with ESMTP id 9BDE9D1E94C
for <pgsql-general@postgresql.org>; Fri, 19 Mar 2004 07:24:12 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
by news.hub.org (8.12.9/8.12.9) with ESMTP id i2JBOA1Y086882
for <pgsql-general@postgresql.org>; Fri, 19 Mar 2004 11:24:10 GMT
(envelope-from news@news.hub.org)
Received: (from news@localhost)
by news.hub.org (8.12.9/8.12.9/Submit) id i2JAx4M4082819
for pgsql-general@postgresql.org; Fri, 19 Mar 2004 10:59:04 GMT
From: chanc@thailand.net (chanc)
X-Newsgroups: comp.databases.postgresql.general
Subject: Does ora2pg work with Oracle9i?
Date: 19 Mar 2004 02:58:55 -0800
Organization: http://groups.google.com
Lines: 17
Message-ID: <d0551d45.0403190258.69b3e494@posting.google.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: groups-abuse@google.com
To: pgsql-general@postgresql.org
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200403/934
X-Sequence-Number: 58978
I got this kind of error message when trying to copy out from
Oracle9i.
[Red Hat 8.0, Oracle9i Release 2, DBI-1.42, DBD-Oracle-1.15,
DBD-Pg-1.32, ora2pg-2.1]
DBD::Oracle::db prepare failed: ORA-00942: table or view does not
exist (DBD ERROR: error possibly near <*> indicator at char 46 in
'SELECT COUNTRY_ID,COUNTRY_NAME,REGION_ID FROM <*>COUNTRIES') [for
Statement "SELECT COUNTRY_ID,COUNTRY_NAME,REGION_ID FROM COUNTRIES"]
at Ora2Pg.pm line 1321.
Can't call method "errstr" on an undefined value at Ora2Pg.pm line
1321.
Does anyone successfully use ora2pg to copy data from Oracle9i?
Regards,
Chanc
On Fri, 2004-03-26 at 09:28, Patrick Hatcher wrote:
While trying to find the physical disk space size each table in our
database (by matching the file name in the base directory to an entry
in pg_class), we found 4 files that constitute 5gigs that we cannot
match back to a entry in pg_class.
Is it safe to delete these?
I feel like you're holding a gun asking if it's ok to shoot, but you
haven't told us which way it's pointing. I'd be curious to know the
filenames in question and the query your running to look for these
files... might also suggest doing a vacuum full on your cluster to see
if their filesizes change at all... but if you've got that cowboy
feeling going i'd say shutdown the database, backup the directory,
delete the files, and fire it back up...
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL