backup/restore

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 5 Nov 2002 12:13:09 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702E1CBAF@lnewton.leeds.lfs.co.uk>

Morning,

I don't know how to extract a proc by itself, but in this situation I'd create a dummy user, import the file but with ROWS=NO GRANTS=NO INDEXES=NO (etc - it depends on your version, 8i allows CONSTRAINTS as well) so only thebare bones of the user will be imported - then copy the proc over to the user that needs it.

HTH Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: s Lehaire [mailto:s.lehaire_at_meilleuregestion.com] Posted At: Tuesday, November 05, 2002 11:05 AM Posted To: server
Conversation: backup/restore
Subject: backup/restore

Hi,
I've got a backup file (dmp file) and I want to restore one of my procedure
which have been deleted.
I know how to restore one table : imp ME/MYPASS_at_MYBASE table=MYTABLE FROMUSER=OTHER TOUSER=ME
or many : imp ME/MYPASS_at_MYBASE table=(MYTABLE1,MYTABLE2) FROMUSER=OTHER TOUSER=ME but not a proc

So if you can help me
thx Received on Tue Nov 05 2002 - 06:13:09 CST