Re: Oracle8 Export/Import

Cindy,

when the database was built, a number of scripts should have been run (catproc/catalog etc). These should also have created the tables etc required for exporting (catexp is called from within catalog). Luckily the catexp script can be run by itself, but it should be run as INTERNAL or SYS as the following extract from the script details :

Rem Copyright (c) 1987, 1995, 1996, 1997, 1998, 1999 by Oracle Corporation
Rem NAME
REM CATEXP.SQL - CATalog EXPort/import sql script Rem FUNCTION
Rem Creates internal views for Export/Import utility Rem NOTES
Rem Must be run when connected to SYS or INTERNAL.

Kind regards, Norman.

PS. As far as Personal Oracle is concerned, I presume the same rules apply to allow exporting and importing.

[Quoted] Norman Dunbar		EMail:	NDunbar_at_LynxFinancialSystems.co.uk
Technical Consultant		Phone:	0113 289 6265
Lynx Financial Systems Ltd.	Fax:	0113 201 7265
			URL:	http://www.LynxFinancialSystems.com
------------------------------------------------------------------------

-----Original Message-----
From: Yunxiang Ren [mailto:yren1_at_gl.umbc.edu] Conversation: Oracle8 Export/Import

>> 1. Can you do Export/Import on Oracle8 Personal Edition?
 

>> 2. When running CATEXP.SQL file before Exporting, why some of the
 tables
>> referenced in CATEXP.SQL don't exit in the database?
>> The WHERE clause uses SYS.ts$ -- this doesn't mean I have to be
 logged
>> in as SYS right?
Received on Wed Jun 07 2000 - 00:00:00 CEST