? ORA-04031
hello ... i got the following error from a full export ... . exporting posttables actions EXP-8: ORACLE error 4031 encountered ORA-04031: unable to allocate 4080 bytes of shared memory (shared pool,DBMS_REPCAT,PL/SQL MPCODE,B AMIMA: Bam Buffer) ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 ORA-06512: at SYS.DBMS_SYS_SQL, line 781 ORA-06512: at SYS.DBMS_SQL, line 316 ORA-06512: at SYS.DBMS_EXPORT_EXTENSION, line 82 ORA-06512: at SYS.DBMS_EXPORT_EXTENSION, line 133 ORA-06512: at line 1 EXP-0: Export terminated unsuccessfully i think it might have something to do with some failed rman backups, and the shared memory segments not being freed up ... but i would appreciate your help in resolving this problem ... thank you in advance ... Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 [EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT - Best book to learn 8i
oracle dba 101 by theriault, carmichael and viscusi a must for surving as a newbie oracle dba Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Thursday, August 23, 2001 3:56 PM To: Multiple recipients of list ORACLE-L Hi all, I am new to the Oracle world but have using Microsoft SQL 7 for a few years. I am looking for any recommendations on the best books to learn about how to understand and administer things in Oracle 8i. Thanks in advance, Kevin -- Kevin Bachelder Microsoft Certified Systems Engineer - Windows NT 4.0 (MCSE) Microsoft Certified Professional - Windows 2000 (MCP) Citrix Certified Administrator (CCA) CompTIA A+ Certified Computer Repair Technician (A+) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Bachelder INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN cold backup?
yes using netbackup and rman ...
cold_backup.rcv
#
# Shutdown the database for cold backup
#
shutdown immediate;
startup mount;
#
# Backs up the whole database cold - consistent -.
# Weekly occurence in our strategy.
#
run {
allocate channel t1 type 'SBT_TAPE';
setlimit channel t1 kbytes 2097150 maxopenfiles 32 readrate 200;
backup
filesperset 12
format 'C_df_i0_t%t_s%s_p%p'
database;
alter database open;
release channel t1;
}
#
cold_backup.sh
#!/bin/ksh
# Sample script which is run from the target database
. ~oracle/.profile
ORACLE_SID=mydb
RMAN_SRC=/u01/app/oracle/admin/mydb/rman
RMANLOG=/u01/app/oracle/admin/mydb/rman/rman_cold_`date '+%y%m%d'`.log
rman rcvcat userid/password@rcat target / cmdfile
${RMAN_SRC}/cold_backup.rcv msglog ${RMANLOG}
hope this helps ...
Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd.
Boca Raton, Florida 33487
[EMAIL PROTECTED]
Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695
-Original Message-
Sent: Tuesday, August 14, 2001 5:54 PM
To: Multiple recipients of list ORACLE-L
I'm frantically R'ing TFM, but I can't find the answer to a simple question:
Can I use RMAN to perform a cold backup? If so, how? TIA!
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
This transmission may contain information that is privileged, confidential
and exempt from disclosure under applicable law.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED.
If you received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic or
hard copy format.
Thank you
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Glasrot, Nechama
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: List slow today?
no ... they were just laid off Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Thursday, August 09, 2001 3:51 PM To: Multiple recipients of list ORACLE-L I think all the people with Oracle problems took the day off. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Stephen Andert [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 4:16 PM To: Multiple recipients of list ORACLE-L Subject:OT: List slow today? Other than during IOUG-A, I haven't seen this few messages. Is my mail server eating messages or is it just a slow day? Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: BIG PROBLEM
One possible reason is that someone might have deleted some archived logs before doing a backup ... solution: log into rman rman rcvcat rman/password target / change archivelog all crosscheck; allocate channel for maintenance type 'SBT_TAPE'; delete expired backup; exit the above is for a separate rman database running on a sun box using a netbackup tape system ... hth Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Friday, June 29, 2001 3:51 PM To: Multiple recipients of list ORACLE-L Hello all, I just joined this list today and am in need of desperate help!!! In its infinite wisdom HR decided to lay off our only oracle dba!!! I am trying to get some backups working on our database using rman. It seems to backup our datafiles ok, but I am getting the following error ... RMAN-03022: compiling command: backup RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: backup RMAN-06089: archived log /oradata/bdw/disk01/archive/bdw_1_24445.arc not found or out of sync with catalog The problem here is twofold: 1) It is looking in the wrong directory for the archive logs 2) We have been moving old archive logs off of the server to another server to keep the disk from filling up while we were working on this backup problem, so I do not want it looking for the old logs. As I am not a DBA I have no clue how to fix this, but it needs to be done A.S.A.P. ... Thanks to anyone who can help me!!! -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using Recovery Catalog with RMAN
hi ... we keep the rman database on a separate server, and back it up to one of the servers that has the database ... hth Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Friday, June 22, 2001 6:11 PM To: Multiple recipients of list ORACLE-L Solaris 2.6 Oracle 8.1.6 What are some practical ways that people have came up with to protect the RMAN recovery catalog? We have the catalog in a separate database on the same box as the database we are wanting to backup. The situation came up recently where the all three control files for both databases were corrupted by an attempted OS upgrade. So we could not bring up the database that contained the Recovery Catalog. How are people approaching the backup of the database which contains the Recovery Catalog? All input is appreciated Don Bricker Information Systems Analyst Illinois Environmental Protection Agency 1021 North Grand Avenue East Mail Code #32 Springfield, IL 62794-9276 [EMAIL PROTECTED] (217) 558-2290 This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: fine-grained export/import access
absolutely ... i just had the same case ... 1/ user one can always export his/her own schema ... 2/ GRANT BECOME USER to user2 3/ user2 can now import user1's export warning ... if user1 has dba privileges then user2 cannot import hth Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 11:52 AM To: Multiple recipients of list ORACLE-L We need to allow a user to export/import a different user's objects. We want to limit access to the designated schema, so we're trying to avoid granting EXPORT/IMPORT_FULL_DATABASE. We don't want passwords embedded within scripts either, for obvious reasons. Is there any way to do this? -- My employers like me, but not enough to let me speak for them. Greg Norris Sprint LTD Database Administration This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ADMIN: Please vote (was: RE: OT SPAM : Become an Oracle
got it ... close it ... Nechama Glasrot Oracle DBA Seisint, Inc.6601 Park of Commerce Blvd. Boca Raton, Florida 33487nglasrot@seisint.com Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 14, 2001 3:57 PMTo: Multiple recipients of list ORACLE-LSubject: ADMIN: Please vote (was: RE: OT SPAM : Become an Oraclevote for close [EMAIL PROTECTED] 6/14/01 3:25:48 PM I too got it, so I'm presuming they harvested this list. I'll take a lookinto the logs when I return from this business trip I'm on. I appreciateall the confirming responses. Should I find that they harvested the list,they will be removed and banned from all lists here (this is policy).However, it's becoming apparent that more spammers find this list useful andharvest from it. I have the ability to hide the subscriber list fromeveryone. I don't typically do this because there are legitimate reasons toallow people to view the subscriber list. In cases of abuse, it's a common(and effective) way to mitigate the problem. If I hide it, no one will beable to directly harvest addresses.I'll take a short vote. Please respond to me privately (here at thisaddress) if you would prefer to have the subscriber list kept open toanyone, or closed to everyone. I'll close the voting on the 19th. Remember!Don't reply to the list!! :-)Note that this doesn't affect your ability to join or leave the list; itonly affects your ability to do a WHO on the list.thanks,bruceListMaster, Fat City Network Services-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Bruce Bergman INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you seis3.jpg
RE: What stands for i in Oracle 8i
P Nechama Glasrot Oracle DBA Seisint, Inc.6601 Park of Commerce Blvd. Boca Raton, Florida 33487nglasrot@seisint.com Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 06, 2001 1:57 PMTo: Multiple recipients of list ORACLE-LSubject: RE: What stands for i in Oracle 8i My bet isthat i = internet. Do I pass or do I get a big fat "F"? -Original Message-From: Muthaiah [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 06, 2001 11:56 AMTo: Multiple recipients of list ORACLE-LSubject: What stands for i in Oracle 8iHi,I am just curious about to know for what that i stands for in Oracle 8i.Can any one shed some light?Thanks, Muths"Do not go where the path may lead, go instead where there is no path and leave a trail." This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you seis3.jpg
RE: Build an exact copy of a database using export / import
Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Wednesday, May 30, 2001 1:57 PM To: Multiple recipients of list ORACLE-L We use Clones of databases all the time. Its much faster than the Export/import run. We simply take the DB down, copy the data files to a new server in the same file layouts (i.e. ... same directory tree), copy over and change the init file for the new DB name, and bring it up. Then you have to alter the global name. Its a relatively simple process. If there are tablespaces that were in the original one that you do not want over then, at this point, drop any associated objects and drop the tablespaces. -Original Message- Sent: Wednesday, May 30, 2001 11:57 AM To: Multiple recipients of list ORACLE-L Well, depending on the size of the db and some other network stuff, I do the following. I shut down the real db, copy all of the data files, controlfiles and init file to a machine with Oracle on it. Then you can create the service (NT), alter any of the datafiles if necessary (on different logical drive) then you can just bring that bad boy up. Then I just give it a different alias, works for me. However, what do you mean it creates new tablespaces, I have never seen that happen, it just fails miserably for me if the tablespaces don't exist. You could do the full export, create a new user on the new machine and grant become any user to the new user. I believe that then the import would work, I've done it before. Sorry I don't have more, brain is still a littel soft from the weekend. Kev -Original Message- L. Sent: Wednesday, May 30, 2001 12:26 PM To: Multiple recipients of list ORACLE-L When I build a new test database I create the database and run all the required Oracle scripts. Then I do a full import of a production export. This works pretty well but I miss some of the grants and The full import wants to create tablespaces that I may or may not want created. I get a lot of errors on system objects. Does anyone have the proper steps to create an exact copy of a production database using export / import? Thanks! Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
RE: imp/exp privilege ?
Thank you. I did not realize that BECOME USER only allowed you to import someone else's exported schema. This privilege is perfect for what I need. Elegant and simple. Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Tuesday, May 15, 2001 4:46 PM To: Multiple recipients of list ORACLE-L Glasrot, Nechama wrote: How can I create the environment that allows UserA to export his schema, and UserB can import fromuser=UserA touser=UserB. I think the BECOME USER privilege might possibly be what you're looking for. GRANT BECOME USER TO userb; Does that do what you want? It is one of the many privileges that is included in the IMP_FULL_DATABASE role. Short of that, I guess you could have a batch job that runs the import into another schema and allow the second user to read the objects in that schema...that's probably not a new thought to you, though. Bill -- __ http://www.datacraft.com/http://plnet.org/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pribyl INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: imp/exp privilege ?
i believe the reason that you can do an imp fromuser/touser is that either they have dba type privileges, or that they have imp_full_database privileges. I do not wish to give the users those privileges as they can be dangerous. If i am incorrect please let me know as i am still new at this. thank you. Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Wednesday, May 16, 2001 6:23 PM To: Multiple recipients of list ORACLE-L I am curious, why couldn't you just do an import and issue the FROMUSER and the TOUSER? I do it all of the time and it works fine for me. Kev -Original Message- Nechama Sent: Wednesday, May 16, 2001 5:56 PM To: Multiple recipients of list ORACLE-L Thank you. I did not realize that BECOME USER only allowed you to import someone else's exported schema. This privilege is perfect for what I need. Elegant and simple. Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Tuesday, May 15, 2001 4:46 PM To: Multiple recipients of list ORACLE-L Glasrot, Nechama wrote: How can I create the environment that allows UserA to export his schema, and UserB can import fromuser=UserA touser=UserB. I think the BECOME USER privilege might possibly be what you're looking for. GRANT BECOME USER TO userb; Does that do what you want? It is one of the many privileges that is included in the IMP_FULL_DATABASE role. Short of that, I guess you could have a batch job that runs the import into another schema and allow the second user to read the objects in that schema...that's probably not a new thought to you, though. Bill -- __ http://www.datacraft.com/http://plnet.org/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pribyl INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard
imp/exp privilege ?
Good morning all, Scenario: UserA/sid=testA UserB/sid=testB Problem: How can I create the environment that allows UserA to export his schema, and UserB can import fromuser=UserA touser=UserB. I do NOT want to grant the roles imp_full_database/exp_full_database to these users, because this allows them too many dba-type privileges including create tablespace, etc. Any help would be greatly appreciated. TIA Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot mailto:[EMAIL PROTECTED] This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fwd: please help
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fwd: please help
a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Year End???
yes and yes Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Thursday, April 26, 2001 11:41 AM To: Multiple recipients of list ORACLE-L I have heard, but have not been able to confirm that May is Oracle's fiscal year-end. Does anyone have any information regarding this? I have also heard that May, being Oracles' year-end is the best month to buy. Has anyone had experience with this? -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
2 RMAN questions
hi listers ... 1/ i had to delete archived logs before i could back them up thru rman ...my ? is how do i notify rman that these logs no longer exist ... do i crosscheck (mark as expired) all previous logs and then issue a complete resynch ... or do i just resynch ... or ? 2/ i am changing the archived logs destination ... is it sufficient to shutdown and restart the database, and then take a backup thru rman ... or do i need to do something else ... i am having trouble finding documentation that addresses these issues specifically ... so tia for help and/or place to research ... Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle being scalable
that page has been moved ... colour me surprised! Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Thursday, April 05, 2001 11:27 AM To: Multiple recipients of list ORACLE-L Have you seen this? http://www.oracle.com/ip/deploy/database/featurestory/index.html?wintergrp.h tml Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle being scalable
thank you ... i finally got it Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Thursday, April 05, 2001 1:12 PM To: Multiple recipients of list ORACLE-L The e-mail system chopped up the link, you have to edit it and put the tml back in... unless the page has actually disappeared... You can also get to it from the www.oracle.com main page, it's one of the links. Pat. -Original Message- From: Glasrot, Nechama [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:12 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle being scalable that page has been moved ... colour me surprised! Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Thursday, April 05, 2001 11:27 AM To: Multiple recipients of list ORACLE-L Have you seen this? http://www.oracle.com/ip/deploy/database/featurestory/index.html?wintergrp .h tml Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
