 | | | Oracle List | | How do you set the temporary directory?
You have to run the following commands (both of them!)
TEMPDIR <youre_dir > export TEMPDIR
TMP <youre_dir > export TMP
env | grep MP to check the screate database link templink connect to foo identified by blah using
'(DESCRIPTION 3D
(ADDRESS_LIST 3D
(ADDRESS 3D (PROTOCOL 3D TCP)(HOST 3D 255.255.255.255)(PORT 3D
1521))
Paula
You could create a stored package that your developer could call where
he would pass in his "create " scripts as a string and it would be
created in the schema.
In our development databaThe installations notes (README.html usually) that come with the
patches are a good place to start.
The instructions sometimes need modification due to specifics
in a particular environment which
Here are my commands to do a level 0 backup and backup the archivelogs then
delete them. These are from OEM job which runs the backups.
run {
allocate channel Channel4 type disk format '/dbbacSanjay
Not to the whole schema. It is fairly trivial to generate a sql script
to grant select access to all of the objects to the user (or to a role
that has been granted to the user).
SometHi all
I am having a problem with a 10.1.0.3 database not automatically
starting up when a box is rebooted. The machine is Windows 2003. There
is an old ORACLE_HOME on this box not sure if thatAll
We are just creating CTX type indexes for the first time and I have a
couple of questions.
I know that I need to periodically resync the indexes using the Ctx_ddl
package. We plaHi All
the env is oracle 9iR2.
The PROD instance has 50 tablespaces. a dba has dropped a few say 2
tablespaces accidentally including contents.
The only backup available is rman hot backOn 5/25/05 J. Dex <cemail_219@(protected) > wrote
> This backup/rman script (korn shell) works fine in other environments but
is
> not working in Linux. It gets to this rman line and doesn 't paHi all
on Monday we has a bizzire incident on the DB ended up shooting the pmon
because even 'connect / as sysdba ' wouldn 't connect for over 6 minutes. '
Anyways once the system was up I was mPaula
I do this in my shell script *every* time and AT THE END OF EACH BACKUP I run...FULL ARCH ONLY etc. Even if I have a local Recovery Catalog.
Effectively I now have a current controlfile Hi!
It 's Oracle 9.2.0.4
We set up DB level of audit and on session level
AUDIT ALL BY username by session whenever successful
AUDIT ALL PRIVILEGES BY username by session whenever successfuStankus Paula G would like to recall the message "media management errors ".
--
http //www.freelists.org/webpage/oracle-l
Hell list
I found one interesting question in the oracle metalink the
originator of the question ask that with cost 2 his query is taking
end-less timing to finish.
3D 3D 3D 3D 3D 3D 3D 3DGuys
I am setting up another box and have created a symbolic link from
$ORACLE_HOME/lib to /usr/lib/libnwora.so just as I have on other boxes
according to the documentation you don 't need to getDear All
I 've simple question for you. I have problem when I try to open form & repo
rt via Internet Explorer. My question is how to setting/activate my IAS so
that I can open my form & reporConsider the following table created on both a 9i and 10g Db (16K block
size)
CREATE TABLE AF_TEST ( a CHAR(200 BYTE) b CHAR(100 BYTE) c VARCHAR2(100
BYTE) )
CREATE BITMAP INDEX bi_af_teShrek
I would do a "relink all ". Not because it is necessary now.
But next time you patch Oracle a relink will be becessary.
If the relink fails at that time you do not have any idea
whetherHi Milen
The 'orcl ' part of the password filename is the instance name. So in
your case it should be stby.
I 'm very grateful that you 're proving my statement that in a High
Available configuSome interesting news on PostgreSQL I know some people here uses it too.
Anyone involved in their beta?
http //www.enterprisedb.com/
Richard Ji
--
http //www.freelists.org/webpage/oracle-l
Yeup. "relink all " will do it.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of bill thater
Sent Tuesday May 24 2005 3 27 PM
All
> >duplicate target database
> >until scn|sequence|time
I wonder if any of you all are doing this "duplicate " automatically via
end-to-end script or manually and plugging in the value forOn 5/24/05 Oracle <all_about_oracle@(protected) > wrote
> this is the error I have
> 20
> Specify log { <RET > 3Dsuggested | filename | AUTO | CANCEL}
> 20
> ORA-00283 recovery session canceled dOn 5/24/05 Smith Ron L. <rlsmith@(protected) > wrote
> Was Oracle 8.1.7 ever certified to run on non-x86 Linux?
> 20
> Thanks!
Apparently no you can check that here
http //www.oracle.com/technoDepends on how precise the date columns are... Are you going down to the
milliseconds? Your output only goes to the second...
Vlado Barun M.Sc.
Senior Data Architect Cadre5
www.cadre5.com
OAll databases which you want to access must be in the TNSNAMES.ORA on the
host from which the request orginates. Just put an entry into your
tnsnames.ora for this database.
HTH
Ruth
-----OrWe are going to go with DBMS_SESSION.
The application(s) will establish and clear the context for each
connection (looks good on paper!!).
Thank you again for your input !!!
-----Original Me
Hi
I need to write a PL/SQL function to
show how many times the leap year occurred between two dates.
The maximum range between dates is 10 years.
Please help.
Thanks
Inessa.
--
hHi all
I have an interesting IO and CPU cost calculation
problem.
I am missing something crucial here.
I am doing comparisons of costs for two things to
better understand the costs when di |
|
|
