RE: do not want to import procedures view, etc

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 17 Feb 2004 14:27:19 -0500
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F73057C19A6@xchgbrsm1.corp.espn.pvt>

probably have to hack resource role as well ...=20

Raj

-------------------------------------------------------------------------=

---

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jared.Still_at_radisys.com
Sent: Tuesday, February 17, 2004 2:18 PM To: oracle-l_at_freelists.org
Subject: Re: do not want to import procedures view, etc

revoke create procedure from user;
revoke create view from user;
Set ignore=3Dy when doing the import.

I haven't tried this, but one thing you will need to do is export the data as the owner, and import it as the owner.

If you do the exp/imp as a dba, the views and procedures will be created anyway.

Jared

"George Leonard" <leonarge_at_vodacom.co.za> Sent by: oracle-l-bounce_at_freelists.org
 02/17/2004 03:55 AM
 Please respond to oracle-l

=20

        To:     <oracle-l_at_freelists.org>
        cc:=20
        Subject:        do not want to import procedures view, etc

Hi all
I am about to refresh a system from a production system, but ONLY want to do the data,

Don't want to update any materialized views, normal views, procedures, functions, packages.

Basically only want to truncate the current table and refresh the data.

About 20 000 tables in 30 schemas.

Any idea.

Currently looking at exp/imp but this will also do views and procedures etc...

George
=20

---

=20

George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:george.leonard_at_za.didata.com
Web: http://www.didata.co.za
=20

You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk,=20 Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
=20

"This e-mail is sent on the Terms and Conditions that can be accessed by =

Clicking on this link http://www.vodacom.net/legal/email.asp "

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Feb 17 2004 - 13:27:19 CST