Check with
http://download-west.oracle.com/docs/html/A96167_01/post-inst.htm#sthref548
Make sure to shutdown/start related stuff (viz OAS) that might have been
installed too.
Also, on some UNIX systems, NFS file system from Server A might have been
mounted on Server B. If so, you need to shutdow
how to startup oracle after machine
is bootup?
you must configure your /etc/oratab
Ans:
add this line
your_sid:your_oracle_home:AUTO(auto is keyword)
how to shutdown oracle before Unix is shutdown?
Ans:
I don't think that Oracle provide such feature, but you can write OS script
Hi Greetings,
We are using solaris. I wonder how to startup oracle after machine
is bootup and how to shutdown oracle before unix is shutdown?
I know how to multiplex control files and redo files. It seems to
me that I cannot multiplex data files. Is that true?
Thanks!
Jin
--
Please see the off
Hi Tanel,
I can't remember what is the correct procedure about auto startup Oracle.
I think you are right is located in /var/opt/oracle (my clustering software does it
for me by comfiguring this oratab)
perhaps Jin can read the manual about startup and shutdown, I remember there is one
small cha
Hi!
> how to startup oracle after machine
> is bootup?
> you must configure your /etc/oratab
> Ans:
> add this line
> your_sid:your_oracle_home:AUTO(auto is keyword)
Y or N are the keywords. I don't remember that auto has been mentioned
anywhere. I didn't find any occurrence it in dbstart
n do the shared memory pamater as in the "shmax'
example.
After that it says to set the process limit by using ulimit -u.
And now.. to the questions
Then it has a list of the minimum values of parameters required to run 9i with a
single datbase instance on Linux. My first problem is, I
We are using AQ for long time . No problems so far .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 28, 2003 8:29 PM
> Hi,
>
> I am looking at using Oracle AQ to post messages.I know they are just like
> any other database tab
Title: RE: Oracle AQ monitoring questions
We use AQ extensively on one of our database and have no issues. v$aq provides good interface (but it is very slow, trace it and you'll know why).
Raj
-Original Message-
From: Basavaraja, Ravindra [mailto:[EMAIL PROTECTED]]
Sent: M
Hi,
I am looking at using Oracle AQ to post messages.I know they are just like
any other database table but with some limitations.i have some concerns from
what I have heard from users who have previously used AQ
1.Are there any serious concerns in using AQ.My purpose of using AQ is just
to act l
Please look the following text, which works fine everyday for loading my data into
oracle 9.2
database.
$ORACLE_HOME/bin/sqlldr USERID=your_username/[EMAIL PROTECTED] control=link-summary.ctl
log=link-summary.log
$ more link-summary.ctl
options (rows=9297500, errors=2, bindsize=100, read
nts of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: sqlldr questions
>
> An excellent book for SQL Loader new comers, and experienced users as well, is one
> by Jonathan
> Gennick and Sanjay Mishra : Oracle SQL Loader, The definitive Guide, by O'Reilly.
>
> S
An excellent book for SQL Loader new comers, and experienced users as well, is one by
Jonathan
Gennick and Sanjay Mishra : Oracle SQL Loader, The definitive Guide, by O'Reilly.
Stenphen Andert will agree with me ;)
- Kirti
--- John Dunn <[EMAIL PROTECTED]> wrote:
> I'm a sqlldr newbie. Plat
I'm a sqlldr newbie. Platform is Oracle 9.2.
My question is...can I prevent sqlldr loading any data if there is even a
single bad record, even if it is, for example, the last record? I am using
conventional path
load.
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Aut
Well, the purpose of the original post was to list a set of questions
that, while admittedly "academic" in that they involve facts, cross 1) a
broad cross-section of what a sysadmin might be asked to do and 2) range
from easy to difficult.
The point is not to know the answer to ever
Yeah, wellummm...yeah, okay - that was dumb of me. Here they are:
1) What is an inode?
Answer: An inode is an on-disk data structure that contains information
about a file. Useful things it includes are size, modification time,
and number of links that point to it (among other things)
Bonus
day technique. I think
some probing of the candidate's knowledge of backup and recovery is
appropriate -- which means you kind of have to learn some of that yourself.
I took the liberty of providing what I think are good answers to some of the
questions.
> -Original Message-
>
13) Why is NIS bad?
14) What's the difference between TCP and UDP?
15) How does DNS work? Bonus question: is DNS TCP or UDP?
Then I usually throw in some amorphous questions: tell me about a
performance problem you tracked down and solved, how do you normally
secure a freshly installed S
does DNS work? Bonus question: is DNS TCP or UDP?Then I usually throw in some amorphous questions: tell me about aperformance problem you tracked down and solved, how do you normallysecure a freshly installed Solaris server, etc. Then I follow up withproduct specific questions - oracle, sun cluster, v
ubject: RE: Interview Questions for a Unix Solaris System Admin
>
> These are nice questions. I'm not sure how I would identify if they are
> technical enough to handle the job though.
>
> [EMAIL PROTECTED] wrote:
>
> question #1: Do you realize that your DBA is a
These are nice questions. I'm not sure how I would identify if they are technical enough to handle the job though.[EMAIL PROTECTED] wrote:
question #1: Do you realize that your DBA is a God, and you will obeyhis/her edicts without question?question #2: Are you aware of the daily offering of
never touched an E6500)
12) On an Sbus e-class I/O tray, what performance considerations do I
have to keep in mind when I'm installing Sbus cards?
13) Why is NIS bad?
14) What's the difference between TCP and UDP?
15) How does DNS work? Bonus question: is DNS TCP or UDP?
Then I usually
a system admin
> candidate for our Solaris shop. I've search Google
> and altavista, but haven't come up with any after
> 1999 interview questions. Does anyone have a list
> of interview question or a link to some?
>
>
>
> tia
>
> M
>
>
> --
ginal Message-
> From: M.Godlewski [SMTP:[EMAIL PROTECTED]
> Sent: Tuesday, July 15, 2003 1:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Interview Questions for a Unix Solaris System Admin
>
> I've been asked to interview a system admin candidate
I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some?
tia
M
Do you Yahoo!?
The New Yahoo!
Hi!
IMO, better not to ask offtopic questions, since this is a mailinglist &
there's no possibility to fine-grained control which mails hit our
mailboxes.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Frida
best pl,ace ive seen for java questions are the
sun.com forums.
- Original Message -
From:
purushottam krishna hegde
To: Multiple recipients of list ORACLE-L
Sent: Friday, July 04, 2003 3:59 AM
Subject: Questions on java
hi all,
can i post questions on
Yes, but you may not get any answers.
On Friday 04 July 2003 00:59, purushottam krishna hegde wrote:
> hi all,
>
> can i post questions on java and j2ee PF here?
> waiting for +ve response for all of u
> thanking all
> purushottam hegde
>
>
>
>
>
>
> ---
hi all,
can i post questions on java and j2ee PF here?
waiting for +ve response for all of u
thanking all
purushottam hegde
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
Dan,
> 4) A subsequent statement has several space management
> (activity on fet$
> and uet$) activities. The tablespace/file that is passed in as a bind
> variable are associated with a 'temp' tablespace. However,
> the tablespace
> is set up as dictionary managed. This indicates that sortin
ultiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: 10046 Trace file questions
I am reviewing a 10046 trace file and have come across several questions
(actually more like hypothesis that I want to confirm).
1) The first user statement executed waits onl
I am reviewing a 10046 trace file and have come across several questions (actually
more like hypothesis that I want to confirm).
1) The first user statement executed waits only on SQL*Net to/from client and does not
wait on any db file activity. I presume this means that the data was found in
o
some research.;-) leads me to two questions:
1) are the docs online at technet? [i can't get to technet right now,
needs
a little tuning on our security policies.;-)]
2) how does AUM work? instead of RBS? in conjunction with RBS? [we
have
several duhvelopers who manage to run out of RBS no
Sent: 6/12/2003 2:34 PM
we're looking to upgrade to 91 later this year, so the boss wants me to
do
some research.;-) leads me to two questions:
1) are the docs online at technet? [i can't get to technet right now,
needs
a little tuning on our security policies.;-)]
2) how does AUM work?
tiple recipients of list ORACLE-L
we're looking to upgrade to 91 later this year, so the boss wants me to do
some research.;-) leads me to two questions:
1) are the docs online at technet? [i can't get to technet right now, needs
a little tuning on our security policies.;-)]
2) ho
we're looking to upgrade to 91 later this year, so the boss wants me to do
some research.;-) leads me to two questions:
1) are the docs online at technet? [i can't get to technet right now, needs
a little tuning on our security policies.;-)]
2) how does AUM work? instead o
One answer is: Queueing theory.
It's Chapter 9 of "Optimizing Oracle Performance," if I can ever finish it.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Reykjavik, Ottawa, Dallas, Washington, Denver, Sydney
- Visit www.hotsos.com for schedu
Title: RE: Re[2]: performance questions
Mark,
I do not think this thread is OT ... this is till very much on topic. I have been gaining so many views on SLA ... I love this topic.
Raj
Rajendra dot Jamadagni at
list
ORACLE-L <[EMAIL PROTECTED]>
.com>cc:
Sent by: Subject: Re[2]
Tuesday, June 3, 2003, 10:59:42 PM, you wrote:
MR> 3) If the company has done something which makes it impossible for the
MR> service provider to maintain the SLA then re-negotiation is required.
This is probably harder than it sounds. How does the
service-provider prove that the client has done
D]>
obal.net>cc:
Sent by: Subject: RE: performance questions
NIS WILLIAMS
>
>
> <[EMAIL PROTECTED]To:
> Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
>
UCH.COM> cc:
Sent by: Subject: RE: performance questions
i say the load profile et al.
there have been cases where i have been asked questions like why this query
took more time than SLA when it was running ok sometime back. i find it very
difficult to convince saying that ther! e are factors affecting this and not
just explain plan et al(correct me if i am
on a single box-single db kind of env
and now the same box has more databases),memory,network,disk
performance,number of transactions or can i say the load profile et al.
there have been cases where i have been asked questions like why this query
took more time than SLA when it was running ok some
kind of env and
now the same box has more databases),memory,network,disk
performance,number of transactions or can i say the load profile et
al. there have been cases where i have been asked questions like why
this query took more time than SLA when it was running ok sometime
back. i find it ve
i say the load profile et al. there have been cases where i have been asked questions like why this query took more time than SLA when it was running ok sometime back. i find it very difficult to convince saying that ther!
e are factors affecting this and not just explain plan et al(correct me if i
Hi
all
Can any body
help in answering these questions
1. What features of Oracle
9i do you recommend to use? Why?
2. What are the features
of Oracle 9i you do not recommend? Why?
3. Have you had any
problems with any of the Oracle 9i features? Please elaborate. If any, how did
you
Hello list,
I will be attending interview on oracle..but the position is for
Maintenance/Implementation of Software.
Could any one of you provide me with set of questions related to
maintenance/Implementation issues in oracle ?
Regards,
Santosh
_
<http://promos.hotbar.c
Hello list,
I
will be attending interview on oracle..but the position is for
Maintenance/Implementation of Software.
Could any one of
you provide me with set of questions related to maintenance/Implementation
issues in oracle ?
Regards,
Santosh
Currently we are use ORACLE developer 6i and plan to
upgrade to IDS 9i. I
heard ORACLE Forms/reports 9i take out client/server
support and use Web browser. my question are:
1. On installation for user's PC does their has way
ONLY install "forms/report run time engine" and
"OC4J"?
2. We don't n
CTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 19, 2003 2:13 PM
> To: Mandar A. Ghosalkar; Multiple recipients of list ORACLE-L;
> [EMAIL PROTECTED]
> Subject: Re:RE: HP-UX Installation questions for 8i/9i on a HP-UX 11/
>
>
> Jeff,
>
> Care to put your 2 c
ndar
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 19, 2003 1:00 PM
> To: Mandar A. Ghosalkar; Multiple recipients of list ORACLE-L;
> [EMAIL PROTECTED]
> Subject: Re:HP-UX Installation questions for 8i/9i on a HP-UX 11/11
gt; [EMAIL PROTECTED]
> Subject: Re:HP-UX Installation questions for 8i/9i on a HP-UX 11/11i
>
>
> Mandar,
>
> I'm going to include my HP-UX GURU on to the reply so
> that he can comment
> about the JFS as he feels appriopriate.
>
> As for trhe MicroF
Mandar,
I'm going to include my HP-UX GURU on to the reply so that he can comment
about the JFS as he feels appriopriate.
As for trhe MicroFocus Cobol, NO you don't need it. Ansi C can become
another matter. If your going to use any exernal procedures you will need it as
well as certain
Installation requirements for 8i/9i on a HP-UX 11/11i on RP7400
Do we need to install Ansi C developers module on HP-UX, if i am not going to use
Pro*C?
Do we need to install Microfocus Cobol module on HP-UX, if i am not going to use
Pro*cobol?
Do u'll use "onlineJFS" (Veritas Filessystem) whi
This message is telling you that your insert violates the
primary key constraint for the table. This means that the
primary key, KUNHOD_TMP1_ID, value in your inserted record already
exists in the table.
HTH,
Peter Schauss
-Original Message-
Sent: Wednesday, March 19, 2003 4:16 AM
To:
You are trying to insert a row that contains values that already exist in
the table, and there is a constraint on the table that says the values for
the row(s) must be unique.
Now about that column BONGID ... What are you smoking?
> -Original Message-
>
> Hallo,
>
> I get this errorme
Hallo,
I get this errormessage while inserting to this table. How can I check this constraint
problem? Any wrong with the table definition
9.03.2003 09:46:38 Db_Transfil.AVSTEM -> ORA-2: db_filtype_ik.AVS
TEM: -> ORA-2: db_filtype_ik:OVERFOR_TIL_KUN:
I have three questions pertaining to the hardware for Oracle 9ias with the
infrastructure.
1) The server we are looking at purchasing comes with a choice of 2
processors. One is a 2.8 GHz with 512KB cache, the other is 2.0 GHz with 2MB
cache. Does anybody have any suggestions or experience with
The Oracle Names utility namesctl or namesctl.exe on WinNT starts the Names
Service. It can also be started from the Services page of the control
panel. The names.ora file contains the configuration information as well
as sqlnet.ora. The Net8 Configuration Assistant can be used to configure
the N
opinions and statements above are entirely my own and not those of my
employer or clients **
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 21, 2003 8:35 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Name Server quest
Hi DBAs,
Oracle 8.1.6 WinNT
I am trying to understand how Oracle Names is configured. We have a Oracle
Names database on server 1.
We also have 2 other oraclenames services on server 2 and 3. I understand
how server 1 was created and works.
What I do not understand is the services on server 2 an
> -Original Message-
> From: John Dunn [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 12:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Questions for Oracle list
>
>
> > Question 1)
> >
> > I've got a update
> Question 1)
>
> I've got a update trigger on a table that updates a record in another
> table.
>
> i.e.
>
> CREATE OR REPLACE TRIGGER table1_trigger_update
> BEFORE UPDATE ON table1
> FOR EACH ROW
> BEGIN
>
> UPDATE
> Table2
> SET
> Table2.version = Table2.version + 1
No shark flash-copy usage here
I think your going to need a bigger boat!
Cheers!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/7/2003 3:23 PM
Resending, just wondering if there any Shark FlashCopy users out there.
So far, it doesn't look good.
Gene
>
Resending, just wondering if there any Shark FlashCopy users out
there. So far, it doesn't look good.
Gene>>> [EMAIL PROTECTED] 02/06/03 05:03PM
>>>
Excellent thread on VLDB and backups. I know EMC BCVs/Timefinder
works for quick disk backups from experience. However, EMC is not an
option
Oops... didn't catch the disk backup bit. Backing up 1TB to disk?? Wow!
Still, the same rules would apply. lots of disks to spread the backup IO
over :-)
RF
-Original Message-
Brian
Sent: Thursday, February 06, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L
This is ok fo
Excellent thread on VLDB and backups. I know EMC BCVs/Timefinder
works for quick disk backups from experience. However, EMC is not an
option, we are a IBM shop w/ Shark storage, Raid-5. The IBM reps say
flashcopy works the same if not better than EMC BCVs. Question, is this
pure marketin
o: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: RMAN - questions.. Rob Freeman?
I am considering doing an rman to disk backup and recovery solution for a
500G-- grow to 1terabyte
database. Monster HP servers ... up t0 16 cpu, upto 10,
Thanks Dennis...
Ya.. its all on disk and problably only a test with some tuning is going
to give me realistic picture. I am going to try it on NETAPPS new disaster
recovery SAN solution
Brian Spears
-Original Message-
Sent: Wednesday, February 05, 2003 3:50 PM
To: Multiple recipients o
This is ok for tape restores but not for disk restore...but thanks Rob.
Brian Spears
-Original Message-
Sent: Wednesday, February 05, 2003 4:36 PM
To: Multiple recipients of list ORACLE-L
Take a look at this link, it might be helpful...
http://portal1.legato.com/resources/whitepapers/W
Take a look at this link, it might be helpful...
http://portal1.legato.com/resources/whitepapers/W012.pdf
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/5/2003 2:16 PM
I am considering doing an rman to disk backup and recovery solution for
a
500G-- grow to
Is this all live OLTP type data, or might some of the data be made
read-only? How much will the data be growing and changing (if not a great
deal then look into incrementals). I can't begin to guess at the time
required those numbers are all factors of:
1. # of backup devices you will be backi
Brian - Hopefully Robert will have a chance to respond to your question, but
if I might make some suggestions, I think your recovery time has two
components:
1. If the backup files are not on disk, the time to locate the tape, load
the files.
2. RMAN recovery time. I think you will just have to
AIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06-02-2003 06:16 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: RMAN - questions.. Rob Freeman?
I am considering doing an rman to disk backup and recove
I am considering doing an rman to disk backup and recovery solution for a
500G-- grow to 1terabyte
database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users
This rman would be the secondary recovery solution (Timefinder is the
first).
Anybody know time frames I might be ab
/dbascripts/rman/debug
2>&1- End go.ksh
--Original
Message- Oracle environment: 3 x 8.1.6 databases + 23 x 8.1.7
databases on 3 serversrunning AIX 4.3.3. My plan is to use RMAN
9i, Legato Module for Oracle without a catalog andhave
After looking at my post, I thought maybe showing the contents of the
directories involved might help show the logic (??) of the script.
/u05/oracle/admin> ls
ACP1/ HLPP/ HRP1/ INTP/ MOBP/ RCNP/ RSAP/ TIMP/
/u05/oracle/admin/ACP1/backup> ls -l
-rw-r- 1 oracle dba3645440 Jan
8.1.6 databases + 23 x 8.1.7 databases on 3 servers
running AIX 4.3.3.
My plan is to use RMAN 9i, Legato Module for Oracle without a catalog and
have all databases in archivelog mode. Databases will be backed up
incrementally and full.
Questions below:
1) Will RMAN 9iR2 support 8.1.6 &
ty
matrix and it doesn't answer one of my questions. I listed my questions
below:
Oracle environment: 3 x 8.1.6 databases + 23 x 8.1.7 databases on 3 servers
running AIX 4.3.3.
My plan is to use RMAN 9i, Legato Module for Oracle without a catalog and
have all databases in archivelog mo
Hi All,
We refresh the snapshots using refresh groups in replication manager of Oracle 8.0.6.
We can schedule the refresh group to refresh the snapshots daily.
Q1. I was wondering if there is any way to schedule the refresh for 5 days(Monday thru
Friday) instead of all 7 days?
Q2. Whenever th
Having been independent for over 20 years, and now a permanent employee (if
anything is permanent) for the past three years, one idea might be to
"broker" your services through placement or consulting firms where you have
a better idea of the companies background and what you are getting in to.
For
I have gone the consulting route three times in my
career. Here are some observations in no particular
order of importance.
Solo is a tough way to go. You have to find the
business and do the work. Either, done right is a
full time job.
In spite of the fact that as professionals we place a
lot
Title: RE: career questions
Hi Maria,
Having bounced back and forth between consulting and being an employee I'd go for it. Whether you should go for it or whether you will enjoy the "consultant" role is a matter of personal preference. One way to find out is to just jump
Maria - I think John has offered some very good advice. Often DBA tasks can
be split into development support tasks and production support tasks. At
larger sites these may be separate jobs.
When you say you are thinking of part-time DBA work, are you thinking of
marketing yourself, or seeking a
Good question Maria and something a lot of us on the list either do, have
done or have considered.
I have no intention of questioning your abilities but being the sole DBA on
a site it is quite easy to be seen as a good dba because the users and your
management have nothing to compare against.
It i
Gurus,
I have been an Oracle DBA for almost 5 years and would like very
much to venture into independent Oracle consulting (part-time). As i
have spent most of these 5 years as a sole DBA for different companies,
studying and learning the ropes of Oracle Administration through books,
magazines
Actually, even without the date field, queries will still benefit from the
partition-wise join on the charge_id column. You would see something like this
(partition hash all) in the plan:
SELECT STATEMENT CHOOSE (Cost=178026)
PARTITION HASH ALL 1:4:1
HASH JOIN
PARTITION RANGE ALL
IL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 22, 2002 8:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: partitioning questions
>
>
>
> Hello,
>
> We are planning to move to Oracle 9.2 on as-yet-undecided platform
> (probably red ha
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: partitioning questions
>Date: Fri, 22 Nov 2002 08:08:55 -0800
>
>That was not a good buy. Partitioning comes with Oracle 9, partitioning
>option is no longer sold separately.
>
>
[mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 22, 2002 8:44 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: partitioning questions
> >
> >
> >
> > Hello,
> >
> > We are planning to move to Oracle 9.2 on as-yet-undecided
buy. Partitioning comes with Oracle 9, partitioning
> option is no longer sold separately.
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 22, 2002 8:44 AM
> > To: Multipl
CLE-L
> Subject: partitioning questions
>
>
>
> Hello,
>
> We are planning to move to Oracle 9.2 on as-yet-undecided platform
> (probably red hat linux on ibm hardware).
>
> We finally pursuaded management to purchase the partitioning
> license, and I have some q
[EMAIL PROTECTED] wrote:
>
> Hello,
>
> We are planning to move to Oracle 9.2 on as-yet-undecided platform
> (probably red hat linux on ibm hardware).
>
> We finally pursuaded management to purchase the partitioning
> license, and I have some questions on partitioning
Hello,
We are planning to move to Oracle 9.2 on as-yet-undecided platform
(probably red hat linux on ibm hardware).
We finally pursuaded management to purchase the partitioning
license, and I have some questions on partitioning:
Scenario:
Range-Partition tableA on a service_date field by year
Ron,
1)Those temp data files to be removed from OS manually. make sure that temp
tablespace dropped successfully.
2) for temporary temp tablespace datafiles are shown in dba_temp_files view
(if tablespace is not dropped)
HTH,
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple rec
list,
additional information that needs clarification.
After the Temporary tablespace fubar had been dropped the datafile
still existed on the OS level. If you have space problems be sure to
look at both your permanant and temporary tablespaces. Temporary
tablespace do NOT show up in the dba_data_f
I HAVE read the Data Guard Concepts and Administration manual
(repeatedly)and will re-read it several more times.
Questions:
1. Any other publications, articles, white papers to follow up on?
2. Has anybody implemented this (9.2 on AIX with IBM Shark storage) and with
what level of succes
My organisation is planning to implement Plumtree
as a Corporate Portal.
We have done a smaller implementation of Oracle 9iAS Portal
and Oracle iFS and I am familiar with these two products.
I have had some experiences where there has been hard-coding of hostnames/portnumbers
inside of iFS and
Hi All,
I want to load PDF files into the database and view the content of the lobs column. Below is what I did step by step. Anyone please point out what did I do wrong in my procedure. I am still unable to view the content of the Lobs column. I need you all for your help.
Please note that
101 - 200 of 717 matches
Mail list logo