Where are these tables??

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Where are these tables??
Date: 2004-03-26 14:28:31
Message-ID: OFC3BFFCF6.47BC2B3A-ON88256E63.004F83D6-88256E63.004F8411@fds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<FONT face="Default Sans Serif, Verdana, Arial, Helvetica, sans-serif" size=2><DIV>&nbsp;</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&nbsp;an entry in&nbsp;pg_class),&nbsp; 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?&nbsp; </DIV><DIV>&nbsp;</DIV><DIV>TIA<br>Patrick&nbsp;Hatcher<br></DIV></DIV></FONT>
>From pgsql-general-owner(at)postgresql(dot)org Fri Mar 26 10:43:49 2004
X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [200.46.204.2])
by svr1.postgresql.org (Postfix) with ESMTP id A11EFD1BA68
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)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(dot)org(at)localhost(dot)postgresql(dot)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(at)postgresql(dot)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(at)postgresql(dot)org>; Fri, 19 Mar 2004 11:24:10 GMT
(envelope-from news(at)news(dot)hub(dot)org)
Received: (from news(at)localhost)
by news.hub.org (8.12.9/8.12.9/Submit) id i2JAx4M4082819
for pgsql-general(at)postgresql(dot)org; Fri, 19 Mar 2004 10:59:04 GMT
From: chanc(at)thailand(dot)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(dot)0403190258(dot)69b3e494(at)posting(dot)google(dot)com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: groups-abuse(at)google(dot)com
To: pgsql-general(at)postgresql(dot)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

Attachment Content-Type Size
unknown_filename text/html 2.7 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2004-03-26 15:26:16 Passing a row
Previous Message Anony Mous 2004-03-26 14:28:11 Re: pg_dump "what if?"