 | | | Oracle List | | Well obviously I 'm not Niall )
But yes you can create it manually and it 'll perform the same way as
when created by Universal Installer.
Igor Neyman OCP DBA
ineyman@(protected)
---Sonja
A simple way of doing this is to not perform a full export. Just
export the
schema/users that have data. This is my preferred method of
export/import.
Tom
-----Original MessagKevin Bass wrote
>Hello
>
>I am converting my Perl program into an Oracle package but I have run
>into a small problem. I have been successfully except for a minor
>problem. I would like to sepI seem to remember someone saying that DBMS_UTILITY has a routine to do
that. Something like comma_to_tab maybe? I 've never used it myself so let
us know what you find.
Jon Knight
-----OI have used ERWIN for a few years Designer and recently was asked to
check out Embarcadero 's ER/STUDIO - I loved it - it has a repository.
You can download an evaluation version. It 's ability to bHi all
After we cloned a db (8.1.7.4) to another server which has the same # CPU
there is one frequently executed stored procedure that is doing 3 to 4
more times
buffer gets per execution thanHello
I am converting my Perl program into an Oracle package but I have run
into a small problem. I have been successfully except for a minor
problem. I would like to separate a value of 1-2-3Jeff
Just a wild guess but are you having any DNS issues?
(domain name changes DHCP server going bonkers collisions with
respect to another host grabbing that same IP address etc.)
(Ok tI would vote for creating new 10g OMS setup. Installation is very
smooth and works pretty well.
On Wed 2 Feb 2005 17 24 32 -0500 Spears Brian
<BSpears@(protected) > wrote
>
> We are
Mladen Gogala wrote
>Sam Reddy wrote
>
>
>
> >Why there are two of these options ?
> >
> >
> >
> >
> >
>There is no difference. Those two options both produce a backup of
>controYou pretty much had it.
Linux
#!bin/sh
echo `date --date 3D$1/12/2005 +%b`
Other Unix OS 's
#!bin/sh
echo `date -d 3D$1/12/2005 +%b`
Your script could just ececute this script however it Kathy
Did you ever find a solution?
Jon Knight
-----Original Message-----
From oracle-l-bounce@(protected) [mailto oracle-l-bounce@(protected)]
On Behalf Of Duret Kathy
Sent WednHas anyone had any luck using ASM with Fedora? I 'd like check out ASM
but I 'm currently running Fedora FC3. The prebuilt packages check for
RedHat EL kernel. Has anyone had any luck compiling and uWe 'll as stated by the deadlock graph the other session is not waiting on
a row lock but probably an index lock since the lock type is TX.
I would guess that either the both sessions are trying Gzip (man gzip) is what you 're looking for. Make sure you 've got a
recent version (not likely to be a problem under Linux but I deal
with quite a few Solaris servers with an ancient release) and Chris
I just tried this in my 817 and 9203 databases and get different results
than you. Both my queries return a row like your 817 example - that is 5
chars in length.
Maybe you have a glogHi Juan Carlos
I can tell you a disvantage. Under win2003 you are not able to do a
RMAN backup on a shared resource mapped as a network drive i.e. if you
want to backup 8with RMAN) to f \ wherWe want to know whether can we down load 10g software for
AMD 64 bit running Solaris 10 ? I looked at technet and there are
two downloads are there one is 64 bit x86 and another one does not sayHi
I want to ask two questions about the following 2 sql statements. The
below tkprof output shows 2 executes for each of them although i
executed each once. Is it because of the select state "Getting Started With Data Guard " document states the following
< <The hardware and operating system architecture on the primary and
standby locations must be the same. For example this means a DatLyndon
From what I read at the website is that the 9i Designer is part of the
10g
Developers Suite.
The download page for Linux Oracle Developer Suite 10g(9.0.4) says
that
this download includ
On 02/01/2005 10 06 13 PM Paul Drake wrote
> win32 - w2k server sp4
> Oracle 10g - 10.1.0.3.
> 20
> how much of a nuisance is hundreds of these trace files when we 're
> not yet using ASH?
>
Different default 8i/9i column lengths when selecting pseudo columns...
This is the issue...
20
3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 20
8.1.7 SQL*Plus 20
3D 3D 3D 3D 3D 3D 3DSean
When I want to do what you are doing this is what I do
Create the new 9i database.
Create any public database links that your application needs.
Create the roles that I need.
Create tHi Sat
If ETL tool is doing bulk (or direct path) inserts (as
it should be) and you can store 100 rows into the db
block then you can have 0.01 block per row if no
indexes/constraints on the taI 've got a query that CBO is generating a "bad " plan for and was wonderi
ng whether anyone could shed some light ...
SELECT T.REVERSAL 5FDATE L.STATISTIC 5FAMOUNT ...
FROM PS 5FJRNL 5FLN L PSJason
I did a presentation (including code) on just that topic at IOUW last year. You can can download it from iouw (paper #500) or my web site. The technique allows you to enable it based on mac
Dennis
I strongly recommend one (RMAN) server one RMAN 9i catalog one RMAN
9i shell script and one long tnsnames.ora file.
simply I say centralize whenever possible.
I created on parAs every one is talking about 10G features this may take us back to
remember the history.
I 've oracle 8174 installed on HP 11.11. I would like to change the
ORACLE_HOME for that installation. IsFigured it out with some help from the list. A user had created a table
called query. Everything we do always references the business owner. So
calling query.mike_test I guess it was looking at the |
|
|
