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?

TIA
Patrick Hatcher

>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 ; 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 ; 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 ; 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 ; 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: 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