Exp Imp Overwirte posiible or not?

Hi All, I want to import data from a user dump file but when i import data, i want to overwrite the existing data . Normally imp utility append data to existing rows. Requirement of application is such that we need to overwrite existing data without dropping objects and its dependent

Re: Insert

well Kevin Kostyszyn, this is true that often we ignore such small issues which sometime impact the performance a lot. ya, it's good if we do inserts and then rebuild the indexes, but generally not done during usual work., since every time u insert records , oracle rebuilds the index itself with

Re: OLAP again

Hi, You are right , Oracle 8i and Oracle Express are 2 different products. In Oracle 9i, Oracle will integrated OLAP server capabilities called OLAP Services, like Microsoft ;-) I'm not sure that OLAP tools are the answer to your needs. OLAP tools are used to stored data in a cube format to

Parallel Server

Do any body worked with Parallel server without a Hardware cluster...i mean just an evaluation of parallel server ...if yes then how??/ Adnan __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail.

RE: Forms Server - MS IIS

Thanks to all who replied. This question got suddenly a nice twist: Oracle support told me, that probably - I have to go to sales to know for shure - I would not be able to get Forms Server without iAS although Forms server is a CGI.exe ... Tamas Szecsy -Original Message- Sent:

RE: How to remove the Ora Lstn services from the WinNT

oradim can be used to delete these services, though I've forgotten the syntax at the moment and don't have any documentation to hand. Failing this, you can also delete the services from the registry if you have permissions, and are happy with doing this. If memory serves they can be found in

RE: How to remove the Ora Lstn services from the WinNT

from the nt resource kit u will get one utility called instsrv . use it to remove the services - NIHAR SANGHVI NetMagic Solutions Pvt. Ltd. 22,Nirlon Complex,Western Express Highway, Goregaon (E), Mumabai 400 063 Phone: 8723003 extn: 144 www.netmagicsolutions.com -Original

RE: Forms Server - MS IIS

Tamas, This question got suddenly a nice twist: Oracle support told me, that probably - I have to go to sales to know for shure - I would not be able to get Forms Server without iAS although Forms server is a CGI.exe ... That's correct. Oracle has bundled it with the Application Server

OT -- Windows Shutdown folder

Does anyone know of an equivalent of the Startup folder in Windows, but that would run just before shutdowns? I found a utility from PC Mag but I was wondering if there was something else out there. This has nothing to do with work, it's for my old Windows95 PC at home. Regards, Patrice

Re: Exp Imp Overwirte posiible or not?

truncate is not an option? Joe [EMAIL PROTECTED] wrote: Hi All, I want to import data from a user dump file but when i import data, i want to overwrite the existing data . Normally imp utility append data to existing rows. Requirement of application is such that we need to overwrite

Re: olap?

Go to Oracle web site and search for Olap... Witold On 26 Mar 2001, at 23:05, [EMAIL PROTECTED] wrote: Hallo, Can anyone tell me: What is OLAP and how does it work, a short description, thanks. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Insert

Usually one drop indexes before massive inserts. Mostly in data loads in DW - if using direct path in SQL*Loader is not an option. It should be decided on the basis if saved time on inserts then time to rebuild an indexes. Also you cannot drop indexes if system should be available during

RE: IOUG university

Anybody knows if they supply aany kind of materials besides standard Powerpoint presentation? Alex Hillman -Original Message- From: Weaver, Walt [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 5:36 PM To: Multiple recipients of list ORACLE-L

RE: Execute priv to an isolated procedure inside a package

I think your idea is the only solution other than yanking out the packaged procedure and making it standalone. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is

Re: Insert

Yes inserting into a table with an index does cause degradation in the process, but it is very unrealistic to drop and rebuild the index every time you do an insert, unless it is a batch process that runs when no other processing is being done. Also, deleting from the index causes the index to be

RE: Execute priv to an isolated procedure inside a package

You can create the wrapper procedure owned by user A. Give this user execute on the package you are wrapping and give users who need to use wrapper execute in wrapper procedure. Alex Hillman -Original Message- From: djordjej [SMTP:[EMAIL PROTECTED]] Sent:

RE: Execute priv to an isolated procedure inside a package

I have not tested this. I believe ,with about a 60% level of confidence, you can place a function/procedure in the body of a package without placing its definition in the package's specification. If so, the function/procedure should not be available when exectute is granted on the package.

RE: Source Code about Java Classes

Just a thought, can you try to use JAD to decompile the Java classes? We are able to mess with ATG Dynamo's code even though they didn't provide us the source. Richard -Original Message- Moriano Sent: Tuesday, March 27, 2001 2:40 AM To: Multiple recipients of list ORACLE-L Hi all,

RE: Insert

Just to add my $0.02 I was working on a large ODS project where we had to process 8+ million records each night into an Oracle 8i database sitting on a RAID-5 disk array. At the start of the processing we trucated the table. We used parallel direct-path SQL*Loader (12 instances). We had

RE: Execute priv to an isolated procedure inside a package

That is correct. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Tuesday, March 27, 2001 8:45 AM To: Multiple recipients of list ORACLE-L I have not tested this. I believe ,with about a 60% level of

RE: Execute priv to an isolated procedure inside a package

Ian, To my understanding you mean local procedure / functions, these then would not be available outside the package. And has to be defined before any local/public function/procedure that uses it. Am I right? Aleem -Original Message- Sent: Tuesday, March 27, 2001 6:45 PM To:

Request Tracker Call for Assistance

Hi All, I have been involved with a perl/DBI trouble ticketing system called Request Tracker. I have done a small piece of the work required to port the system to Oracle. The creators are almost finished but with my new job I cannot devote the time

RE: Execute priv to an isolated procedure inside a package

Ian, You are 100% correct, but then that program unit becomes internal to the package and can only be accessed by other program units in that package. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot

Re: help!!! data migration

Use the compression thru pipes method to do an export of the database. FTP the resulting file(s) to the other server. Make sure you do the FTP in binary mode. Then import it thru a pipe to uncompress it on the way into the database. (This gets around the 2 gig limit on exports.) Look for the

RE: OPS Setup Steps ?

On the 8.1.7 Generic Documentation CD there are four manuals about Parallel Server which should get you started. -Original Message- Sent: Monday, March 26, 2001 4:58 PM To: Multiple recipients of list ORACLE-L Have a Single Instance Database ( ORA 8.1.7 )Running on a 2-node Cluster

RE: OPS Setup Steps ?

Title: RE: OPS Setup Steps ? This is documented in the Oracle 8i Parallel Server Setup and Configuration Guide (chapter nine) and basically consists of the following tasks (copied straight from the doc.) Task 1: Configure Hardware Task 2: Evaluate Tablespaces and Log Files of Single

RE: Solaris security ?

Just make sure that the non-owner performing backup has the UID 0. -Original Message- Sent: Monday, March 26, 2001 8:00 PM To: Multiple recipients of list ORACLE-L Hi guys, (With - Solaris 2.7) Do you have any solution how to allow "non owner" to perform backup ? with "tar command"

RE: OPS

For an OPS configuration, disks have to be shared among the nodes, which usually means some kind of common IO bus (SCSI, FCAL, SSA). That means that the nodes must be within cca. 2 miles (3 km). -Original Message- Sent: Tuesday, March 27, 2001 6:45 AM To: Multiple recipients of list

startup/shutdown scripts for AIX

Hi, Does anybody have a good set of startup/shutdown scripts for Oracle (Release 8.1.7) on IBM's AIX? I mean the kind of scripts that are executed when a certain UNIX runlevel is reached. I would appreciate a copy very much. Thanks in advance, Koen. -- Please see the official ORACLE-L FAQ:

RE: Execute priv to an isolated procedure inside a package

I'm coming late to this thread, but then couldn't you set things up in an OO paradigm and have the accesssible functions(methods) check the userid and control access that way? So if the package is a ccessible by anyone, and function A is the one with no external access, build in functions B, C,

OFF TOPIC: java servlet service provider

Hi, I developed a java servlet based application. I need an ASP. do you know java service provider company ? thanks in advance... = --- Danisment Gazi Unal Web: http://www.geocities.com/danisment ---

Re: Request Tracker Call for Assistance

DISTINCT and UNIQUE in a select are synonyms for each other. They produce the same result in Oracle. [EMAIL PROTECTED] 03/27/01 09:31AM Hi All, I have been involved with a perl/DBI trouble ticketing system called Request Tracker. I have done a small piece of the work

Re: Curious /etc/system settings in Solaris

Hi Louis, There is a Solaris Tunable Parameters Reference Manual available at: http://docs.sun.com:80/ab2/coll.707.1/SOLTUNEPARAMREF/@Ab2TocView?Ab2Lang=CAb2E nc=iso-8859-1 It will describe what these mean. All of these are valid Solaris variables. Basically the msgsys values refer to the msg

What is best practice - differenet schema/different dbs

List, I would like to have your opinion on the following scenario. We are having an application which is used by different customers (around 15 customers). On an average each customer will have around 1,000 transactions per 5 minutes. Now, is it better to have a separate database for each

Re:Request Tracker Call for Assistance

Dave, What would probably be a much better solution is: select column_name1, column_name2, etc... from tablename group by column_name1, column_name2, etc... I've a funny feeling that blob/clob's can't be included in the group by clause so they'll have to specify the column names. Other

No Subject

When I create a function in a package and declare it in the specification section it works fine. When I try and make it private by removing the declaration in the spec section I get the following error trying to compile: PLS-00306: Wrong number or types of arguments in the call to

Re: What is best practice - differenet schema/different dbs

Hi Maheswara, I would think seperate databases would be the way to go, if for no other reason, you can bring one customer offline without affecting the others. -Rocky --- "Rao, Maheswara" [EMAIL PROTECTED] wrote: List, I would like to have your opinion on the following scenario. We are

Re:RE: Execute priv to an isolated procedure inside a packag

Dan, In my experience your statements are absolutely true. Dick Goulet Reply Separator Author: "Dasko; Dan" [EMAIL PROTECTED] Date: 3/27/2001 7:51 AM I'm coming late to this thread, but then couldn't you set things up in an OO paradigm and

CLOB code question

Hello everyone - I'm fiddling with CLOB code for the first time. I have to write a function that will accept a long string of characters from an external application and store it ina CLOB field. Seems to me that since the character data is coming from an outside application, the only

RE: OFF TOPIC: java servlet service provider

Check out http://portalstudio.oracle.com This may (or may not) be helpful! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, March 27, 2001 10:57 AM To: Multiple recipients of list ORACLE-L Hi, I developed a java servlet based application. I need an ASP. do

Issues with Oracle on a Compaq Tru64 5.1 Cluster

We are running Oracle 8.1.6.2.0 on a new Compaq Tru64 cluster running 5.1 patchkit 1. We have had Oracle running for almost 2 months. For the last several days, we have been experiencing severe I/O issues. The databases will freeze-up and claim that they can't access certain files.

RE: help!!! data migration

Nihar, assuming both the db versions are on 8i, how about the export with the direct option and then import it. Prakash -Original Message- Sent: Tuesday, March 27, 2001 1:06 AM To: Multiple recipients of list ORACLE-L hi ppl, i want to migrate oracle database from solaris to NT and

RE: OPS

FYI: They must also be on Raw Partitions!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, March 27, 2001 10:36 AM To: Multiple recipients of list ORACLE-L For an OPS configuration, disks have to be shared among the nodes, which usually means some kind of

RE: What is best practice - differenet schema/different dbs

Having separate databases gives you some flexibility. You can manage them separatly, for instance you can upgrade the database to a newer version in phase. Also, if you lose a database only one customer is affected. Do all the customers always use the same application (same version)? If one

RE:

You have a forward reference. Move the function declaration to the top of the package body and it should work. Kevin Toepke - The information in this electronic mail message is Cendant Confidential and may be legally privileged. It is intended solely for the

Re:What is best practice - differenet schema/different dbs

Rao, I'm going to differ from a previous return post. I think that you should use different schema's with separate tablespaces. Why? Because your all on one machine therefore all of your background Oracle processes are competing for the same CPU, memory, and IO resources which can and

Off Topic Unix question

One of co-workers is going to upgrade from Solaris 2.6 to 2.7(version 7). The question they had is what patch cluster to apply the below web site has 7 x86(21.7m) and 7 (39.8m). Which one to apply? "Rick I was looking at http://sunsolve.sun.com/pub-cgi/show.pl?target=patches/patch-access and

RE: Solaris security ?

UID 0 means root user. Root user by definition can access any file in the system. Rao -Original Message- Sent: Tuesday, March 27, 2001 10:41 AM To: Multiple recipients of list ORACLE-L Just make sure that the non-owner performing backup has the UID 0. -Original Message-

Re: Off Topic Unix question

Hi Rick, x86 refers to the Solaris for Intel version. There are slightly different patches for this version. Assuming you are running on SPARC, you want the non-x86 version. Dave Miller Sun Microsystems, Inc. Date: Tue, 27 Mar 2001 10:05:26 -0800 To: Multiple recipients of list ORACLE-L

RE: Exp Imp Overwirte posiible or not?

The DESTROY option on an import indicates whether the CREATE TABLESPACE commands only found in a full export should be executed. Setting DESTROY=Y destroys the data files of the database being imported into. This is only used when you want to rebuild an entire database, not to overwrite data

Which is faster, Metalink or...

A snail going uphill through jungle vegetation? Molasses in thenorthernmost region of the Siberian tundra?Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.

RE: Exp Imp Overwirte posiible or not?

You can use truncate command to delete all data from that tables and then IMP.Hope this will help u . -Seema From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Exp Imp Overwirte posiible or not? Date: Tue, 27 Mar 2001

LOB ?

LOB question? Can you have db A have a view w/ db link reference to db B blob data type? I think so, but not 100% sure. The reason I ask is I have a 3rd party app that wants to move 500gb worth of images to a remote db, but have the current db reference it as if it was in the same db

RE: Exp Imp Overwirte posiible or not?

Thanks for the correction. I'm away from the doc CD at the moment as we are moving offices... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: William Beilstein [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 1:19 PM To: Multiple recipients of list

Using Profiles to Force Users off After Inactivity

Has this been improved in 8i. When the time has expired does it still issue alter system kill session 'sid,serial#'; or does it now issue alter system kill session 'sid,serial#' immediate; Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] -- Please see the official

OFFTOPIC - RE: Which is faster, Metalink or...

Turtles walking through peanut butter in January? -Original Message-From: Chuck Hamilton [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 27, 2001 2:32 PMTo: Multiple recipients of list ORACLE-LSubject: Which is faster, Metalink or... A snail going uphill through jungle

Issues with Oracle on a Compaq Tru64 5.1 Cluster

Checking this up with a colleague who works at another operator. Get back to you on this Peter -- email: [EMAIL PROTECTED] Oriole Corporation (http://www.oriole.com/) Oracle Performance Tools and Free Scripts Tel: +44 (0)20 7872 5480 Faxes: UK +44(0)705 066 8661 / US +1 240 526 5946

RE: Execute priv to an isolated procedure inside a package

Ian, You are 100% correct. A procedure, function, cursor, etc. not declared in the package spec, but only in the package body is considered private to the package and cannot be executed by any external call, only by calls from other procedures, functions, etc. within the package. That way you

RE: IOUG university

Just don't let the room temperature get below about 80 deg. F, or Gaja's teeth will start chattering and he won't be able to speak! He likes it hot! ;-) It really is worth sweating for an hour or so to hear his stuff - he's good! I had the privilege of working with him for a while a couple

OFFTOPIC - RE: Which is faster, Metalink or...

Water flowing uphill (that never works either) [EMAIL PROTECTED] 03/27/01 02:52PM Turtles walking through peanut butter in January? -Original Message- Sent: Tuesday, March 27, 2001 2:32 PM To: Multiple recipients of list ORACLE-L A snail going uphill through jungle vegetation?

RE: OFFTOPIC - RE: Which is faster, Metalink or...

Metalink, hands down. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Tuesday, March 27, 2001 2:52 PMTo: Multiple recipients of list ORACLE-LSubject: OFFTOPIC - RE: Which is faster, Metalink or... Turtles walking through

A Basic PL/SQL Question

Hi, This is my first attempt at writing a PL/SQL procedure. Everything works fine, except I have a firly large table I am running against. I am trying to display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to 100, apparently the maximum value, but it still isn't

library cache load lock latch

I've some waits on this latch. I've read that a sesion has to get this latch for a database object (always in exclusive mode) in order to LOAD this object (to the LC I assume). And when this latch is busy the session has to wait on the "library cache loda lock event" Does anybody know what can

Trying to find a book...

Hi Gang, Anyone know of a book by Willard Baird? I'd like to like to know the title and any thoughts you may have. TIA, Rocky __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please

Re: LOB ?

I am not quite sure that you can reference a LOB in a remote database through a database link. You are very likely to get the ORA-22992 error when you attempt to do so. 22992, 0, "cannot use LOB locators selected from remote tables" // *Cause: A remote LOB column cannot be referenced. //

RE: Trying to find a book...

http://www.amazon.com/exec/obidos/ASIN/1562058916/qid%3D/107-6190632-5933351 -Original Message- Sent: Tuesday, March 27, 2001 4:16 PM To: Multiple recipients of list ORACLE-L Hi Gang, Anyone know of a book by Willard Baird? I'd like to like to know the title and any thoughts you may

RE: A Basic PL/SQL Question

Use the UTL_FILE package and write the results to a temporary file. Eric -Original Message- Sent: Tuesday, March 27, 2001 4:09 PM To: Multiple recipients of list ORACLE-L Hi, This is my first attempt at writing a PL/SQL procedure. Everything works fine, except I have a firly

Re: Issues with Oracle on a Compaq Tru64 5.1 Cluster

We use COMPAQ tru64 5.1 with Oracle 8.1.7. we had noticed corruption in some all files and had to apply some O/S level patches. We followed the instructions in the following TAR# 13320267.600. You may want to do a dbv on certain files to ensure there is not corruption. Again we did not notice

RE: A Basic PL/SQL Question

Bill, The version 8 PL/SQL manual states: Messages sent using the DBMS_OUTPUT are not actually sent until the sending subprogram or trigger completes. There is no mechanism to flush output during the execution of a procedure. You may want to try using the file i/o facility provided by the

RE: A Basic PL/SQL Question

Bill, Try pushing the output directly to a file using calls to the Utl_File supplied package. That would allow you unlimited spooling capacity. If you really want to use DBMS_Output, you might try (but I don't know if it would work) to call DBMS_Output.Disable then DBMS_Output.Enable(100)

changing db_block_size

all, I would like to change the db_block_size (currently 2048) of our production database and would be interested in hearing from those that have done this on a not so small database. This is our oracle financials/manufacturing server and is about 30GB in size. Did you recreate the database

New born DBA.....

Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank you Sinardy Soon be OCP certified -- Please see the official ORACLE-L FAQ:

Re: changing db_block_size

export and import is your only solution to recreate the database in different db_block_size Winnie Roy Ferguson [EMAIL PROTECTED]@fatcity.com on 03/27/2001 04:40:22 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

Re: changing db_block_size

last i checked that was your only choice, anyone like to flame me for that statement :) joe Roy Ferguson wrote: all, I would like to change the db_block_size (currently 2048) of our production database and would be interested in hearing from those that have done this on a not so

RE: changing db_block_size

Roy, You will have to recreate the database to change db_block_size. Possibly the only way to do this is through export/import. -full export -remove old database -recreate database with new block size. -full import 30Gb database will take approximately 12 hours to complete the job on a medium

Re: New born DBA.....

start by reading the administrators guide and welcome to the world(Dr DBA slaps the bottom side of the newborn) :) joe Sinardy Xing wrote: Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and

RMAN

Dear DBAs, I found this RMAN command on Oracle8i Backup Recovery documentation. This is used to backup all data files and controlfiles. run { allocate channel ch1 type disk; backup database; sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; # archives current redo log sql 'ALTER SYSTEM ARCHIVE LOG ALL';

Re: changing db_block_size

no flame supposedly in 9i you will be able to change the block size while the db is up and will also be able to have different blocksizes -- I think it's by tablespace From: "Joseph S. Testa" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

Import comma-delimited text file into Oracle

Hi! Is SQL*Loader the only way to move the contents of a comma-delimited ASCII file into Oracle? UTL_FILE would be another option, right? Or are there any other ways to do this? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: RMAN

Yes def RMAN will recognise and execute the same. After u have backed up the database, We need to backup the Archivelog and then the controlfiles. This is the sequence in which the backup is done. We need to issue the SQL stmt to archive the current redo log so that we don't loose the

Not abble to connect to the serer.

HI, I can not connet to server , when I run Oracle Application BIS Runtime Repository wizard, after I install the BIS. After I typical install the BIS , I run the wizard. In the APPS schema form no mater how I feed the user and pwd, the wizard tell me : "Not able to connect to the server

2 Databases Problem

Dear Listers , yesterday , I've created 2nd database for Test using Database Assistant on NT. and I also shutdown my Test Server later. this morning , when I tried to Startup both of My DB , I found ORA-01102 error :can not mount database exclusively. My 1st database is able to be started in