| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: script to scan show=y log for create user/grant statements
Adam,
Might the impshow2sql script (or a modification of it) in Metalink note 297= 65.1 be what you're looking for?
Bob Stauffer
D&E Communications
Ephrata, PA USA
717-738-8737
rstauffer_at_decommunications.com
>>> adonahue_at_opsware.com 02/18/2004 17:29:25 >>>
Folks,
Anyone have a pre-written script to scan an imp show=3Dy log file for=20 those statements necessary to create a user, grant it system privileges=20 and roles, prior to performing a fromuser/touser import of its schema? =20 I figured someone must have done this before. Otherwise, I'll quickly=20 come up with one.
Thanks,
Adam
-- Archives are at http://www.freelists.org/archives/oracle-l/=20 FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=20 ----------------------------------------------------------------- **DISCLAIMER This e-mail message and any files transmitted with it are intended for the = use of the individual or entity to which they are addressed and may contain= information that is privileged, proprietary and confidential. If you are n= ot the intended recipient, you may not use, copy or disclose to anyone the = message or any information contained in the message. If you have received t= his communication in error, please notify the sender and delete this e-mail= message. The contents do not represent the opinion of D&E except to the ex= tent that it relates to their official business. ---------------------------------------------------------------- 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 Thu Feb 19 2004 - 07:55:49 CST
 |
 |