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 O
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 .p
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 transacti
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:
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 <[EM
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'; #
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
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
s
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
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 PR
Title: RE: Cleaning up before upgrades / migrations; avoiding upgrade problems
Patrice,
That is what I did:
1. Install 8.1.7.
2. Create new DB.
3. Migrate old DB from 7.3.4 to 8.1.7.
4. Create new LMTs for tables and indexes.
5. Move all tables to new tablespaces (adjust PCTFREE and PCTUSE
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: http://www.or
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
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) e
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 UTL_
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
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 large
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 hav
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.
// *
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
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
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 enough
Hi all,
Someone had answered this already last week, but being the bone head that I
am I forgot to save it. It was something to the effect of seeing how many
processes were waiting to write to the log buffer or something like that.
And it was a good indicator that your log files are too s
Me going upstream against Naigara fall.
-Original Message-
Beilstein
Sent: Tuesday, March 27, 2001 3:19 PM
To: Multiple recipients of list ORACLE-L
Water flowing uphill (that never works either)
>>> [EMAIL PROTECTED] 03/27/01 02:52PM >>>
Turtles walking through peanut butter in January
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
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?
Especially when it's a stampeding herd of turtles!!!
-Original Message-
Sent: Tuesday, March 27, 2001 1:52 PM
To: ORACLE-L
Cc: MohanR
Turtles walking through peanut butter in January?
-Original Message-
Sent: Tuesday, March 27, 2001 2:32 PM
To: Multiple recipients of list ORA
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 of
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 c
> 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 5
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 veget
Has this been improved in 8i. When the time has expired does it still issue
alter system kill session ',serial#';
or does it now issue
alter system kill session ',serial#' immediate;
Ian MacGregor
Stanford Linear Acclerator Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ:
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 ORA
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 throug
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 2
A snail going uphill through jungle vegetation? Molasses in the northernmost region of the Siberian tundra?Do You Yahoo!?
Yahoo! Mail Personal Address -
Get email at your own domain with Yahoo! Mail.
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 in
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 <[E
x87 is the version of Solaris that runs on an Intel based (PC) machine. For sun
hardware, you don't want x86
>>> [EMAIL PROTECTED] 03/27/01 01:05PM >>>
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 si
Rick,
x86 stands for the Intel (processor) version of Solaris...as opposed to the
Spark (processor) version of Solaris.
Ed Haskins
Oracle DBA
Verizon Wireless
-Original Message-
Sent: Tuesday, March 27, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
One of co-workers is going
IIRC, there is a flag for import "destroy=y" to do what you want. This is
very dangerous and you should research all the implications before trying
it. If you don't have the docs, try http://technet.oracle.com and read up
on the import options.
Scott Shafer
San Antonio, TX
210-581-6217
> -
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-
Sent:
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
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 does
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
addressee(s).
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
cu
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 comm
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 v
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. Occass
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 yo
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 in a CLOB field.
Seems
to me that since the character data is coming from an outside application, the
only
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 ha
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
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
functi
Dave,
What would probably be a much better solution is:
select , , etc...
from
group by , , 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 wise do a parent/child table
relation and have the blob/clob
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
cust
Hi Louis,
There is a Solaris Tunable Parameters Reference Manual available at:
http://docs.sun.com:80/ab2/coll.707.1/SOLTUNEPARAMREF/@Ab2TocView?Ab2Lang=C&Ab2E
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
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
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
---
_
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, &
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: ht
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 ORA
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"
F
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 Instan
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 (
Title: RE: OPS
There are some clustering technologies that allow
'campus clusters' (such as SunCluster), but I
don't believe it's possible over a wide geographic
separation.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying t
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 f
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
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 necessa
Try the following command.
oradim80 -delete -srvc
Rao
-Original Message-
Sent: Tuesday, March 27, 2001 4:55 AM
To: Multiple recipients of list ORACLE-L
from the nt resource kit u will get one utility called instsrv . use it to
remove the services
- NIHAR SANGHVI
NetMagic Solution
Azhar,
> Is it possible with exp, imp utilities or i have to delete data
> first and then import using imp utility.
what you describe sounds more like a sqlldr operation.
afaik, the answer is no and you'd have to:
(backup)
(alter database noarchivelog)
- disable FK constraints
- disable trigger
No Windows doesn't have a similar functionality for shutdown. I have used
the PC Mag utility in the past. It did what I needed for shutdown tasks.
On Tuesday 27 March 2001 06:15, you wrote:
> Does anyone know of an equivalent of the Startup folder in Windows, but
> that would run just before s
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: Mult
After having written thousands of lines of PL/SQL procedures to revamp some of
our operational systems I can say with certainty that is you can create a
function/procedure within a package, and not include it in the specification.
Problem is that the procedure/function is totally invisible to any
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 c
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 SQL
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,
[E
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.
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: Mond
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
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 persona
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
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 inserts
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 Sköldblom
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq
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
> overwrit
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 Boivin
Hi all!
Does anyone know is it possible to configure OPS between two remote sites?
TIA,
Sonja
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
Thanks guys.
-Original Message-
Sent: 26 March 2001 18:26
To: Multiple recipients of list ORACLE-L
Direct patch sqlldr (and insert-append) do allow
indexes - its just that you get slugged a little more
on rollback and redo...
I don't have any metrics to compare - typical usage of
eithe
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
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 Message--
HELP!
I am an newer of oracle.
I wanna develop warehouse useing OWB.
After i install the EIS, I run the BIS Runtime Repository Installation wizard
to Create and install into new BIS Repository Schema.
But no matter i feed the APPS Schema user, wizard tell me:
"not able to connect to Oracle Appli
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 HKE
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: 2001.M
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.
http://personal.mail.yahoo.com/?.ref
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 sl
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 sl
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 e
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
objects
98 matches
Mail list logo