Can anyone give me a good example on how this works?
Thanks in advance
Roland
Connor McDonald <[EMAIL PROTECTED]>@fatcity.com den 2001-10-25 01:45 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Kopia:
I
Actually, SYSTEM *is* included in a full export.
This can cause you some problems on import if you
forget about it. The few times I've recreated a database
and populated it with a 'full' export, I've dropped the SYSTEM
user from the new database before running the import.
Since the discussio
Check the
" a.pc_session_user_name = 'tsokol'"
There is no alias "a".
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
"Lance Prais" <[EMAIL PROTECTED]> 22/01/2002 08:15 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
Thanks John and others for very good update.
--
On Mon, 21 Jan 2002 12:10:25
John Kanagaraj wrote:
>Hi all,
>
>I guess this question has been asked many times both in this list and
>offline. I had promised to write this sometime back, so it's time to get
>to the bottom of this:
>
>History: O
Dear all,
Can I create database link using generic connectivity (ODBC)? Was there
someony already try this?
I'm using oracle 8.1.6 on WIN2K box with INGRES NET, and INGRES 6.4 on
VAX/VMS.
TIA,
Holly
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ahmadsyah Alghozi Nugro
>> ( list owner, baby sitter and part time DBA )
Jared, What happened to that Perl thingy ??
Thank you so much for doing a wonderful job in keeping this list going
On your list, I have learnt more than I can offer others. Not only just
Oracle things
I have made a few good friends, for
We have all.. HP-UX, Sun, AIX, Irix etc..
No major issues in the past several years. We had EMC go bad a couple of
times. But all these servers have never crashed on us all of a sudden
(touching wood). A couple of times we did have a couple of HP servers go
down, but it was due to our internal pro
Aint that the truth, open arms and then some :)
joe
[EMAIL PROTECTED] wrote:
> Thanks Joe.
>
> A little OT has usually been acceptable here.
>
> Even some humor. The only time it became a problem
> is when it veered away from having anything to do with
> Oracle and oracle related work issu
Thanks Joe.
A little OT has usually been acceptable here.
Even some humor. The only time it became a problem
is when it veered away from having anything to do with
Oracle and oracle related work issues.
People would start posting ethnic and off color jokes,
ranting about their favorite pet pee
You will be ok. The only issues I have had are the normal hardware issues
(CPU gone bad, etc).
One thing that did concern me though is I was able to crash a box due to
heave IO to one disk. We never did get around to investigating it any
further though before they shut the plant.
-Original
I will have a go at it being
a.pc_session_user_name = 'tsokol'
a doesn't appear to be defined or do you actuall have a table called "a"
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://
How about Singapore for both Oracle OpenWorld and Miracle Master Class ?
;)
I'd even take leave-without-pay and pay for the registration charges myself
to attend, if necessary. ;)
;)
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
"Boivin, Patrice J" <[EMAIL PROTECTE
Tim, i'm with you, and since Paul does not evidently know who the list
owner is here since he's making waves on the very few anymore OT posts
that are here anymore and that the list owner was the one talking about
tribbles.
Paul, feel free to start your own list and manage it as you please.
j
I have the following SQL Statement but am getting and ORA-00904 Invalid
Column Error. What Could I be doing wrong?
SELECT
Launch.oc_session_id
FROM
pt_client_eventdetails launch,
pt_client_eventdetails logout
WHERE
a.pc_session_user_name = 'tsokol'
and (logout.pc_event_op = 'LAUNCH'
Yeah, I've heard the performance arguments before.
I've never worked on a really large OLTP system, but I have
worked on some of 20 gig or so with a few key tables having
millions of rows ( 20 gig used to be big! ).
One in particular had quite a bit of RI. Running on a DG/UX
system with 512M R
Anita:
I'm an idiot.
Next time I'll read your entire message.
(Got so excited to see the patch that I went looking for it before I read
your entire message.
I need to get a life)
Barb
> --
>
>
> --
> From: A. Bardeen[SMTP:[EMAIL PROTECTED]]
> Reply To:
Hi All,
We plan to move our OLTP databases which were accessed
through the internet to Sun Solaris. Could someone who
has done such a thing already tell me if there is
anything I should look out for in this process?
Thanks.
__
Do You Yahoo!?
Send
this is the reason we started the oracle-l off-topic list. to subscribe
just send an email to:
[EMAIL PROTECTED]
--- "Johnston, Tim" <[EMAIL PROTECTED]> wrote:
> My own 2 cents... Stating a viewpoint such as this and then saying
> "do not
> reply to this" is just not a
Yeah !!!
Concurring,
JoJo
-Original Message-
Tim
Sent: Monday, January 21, 2002 2:31 PM
To: Multiple recipients of list ORACLE-L
My own 2 cents... Stating a viewpoint such as this and then saying "do not
reply to this" is just not acceptable... This topic has been discussed on
the l
Excellent
Peter
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane, AustraliaMobile: +61 (0)402 094 238
Title: RE: Limits on referential integrity
Jared and Dennis,
In the J2EE world I've found that developers can have a little trouble with RI because in some cases it is not the developer that is performing the DML operations - the J2EE container does this for them when using Container Managed
Hi
I checked the following events
Name total_waits time_waited
log file switch completion 181188
log file sync 99909 667388
This value is increasing.I checked following stats and found ok.
backgroun
My own 2 cents... Stating a viewpoint such as this and then saying "do not
reply to this" is just not acceptable... This topic has been discussed on
the list innumerable times over the years and it is always a hot bed of
discussion... And, it always seems to reach the same conclusion... In
sum
Systems - A big consideration is whether your application is designed to be
replicated. I have been able to find two books on replication:
Oracle Distributed Systems by Charles Dye. O'Reilly. 1999. This is specific
to Oracle, and is pretty good.
Data Replication - Tools and Techniques for Managi
Jared - I wasn't clear, but then again it is Monday. I have a team of
inexperienced developers starting a big, new Java application. They have a
good, experienced data model consultant helping them create the data model.
They are eager to include referential integrity. So eager it has me a little
I would be you lunch that what they are implementing in their
code is not actually RI. They may be implementing code to
ensure things get inserted in the right order, and that child rows
have a parent.
This is a very weak form of RI. Oracle is very good at implementing
RI, and it is not depend
I have both Sun and HP boxes. IMHO for OS installation and hardware
replacement, Sun is much easier than HP. Actually, I've found everything
easier on Sun, but for the really hard core SA stuff, I do rely on the SA
"gods" here and they probably have a different opinion than I do. My bias
toward
Sundeep,
You couldn't have made a better case for using interMedia Text index(es) on
your CLOB column(s) if you'd had help from Oracle Marketing! ;-)
interMedia Text is very powerful and efficient. We use it to index and
search almost 15 million CLOB documents, many in HTML format. interMedi
On the consulting side, I've seen both. The way I've seen it is if they ask
for an "Apps DBA" the rate is lower than for a DBA, but if they ask for "a
DBA with [Financials|Manufacturing]" the rate is higher.
HTH,
Bambi.
-Original Message-
Sent: Monday, January 21, 2002 3:06 PM
To: Multi
How much referential integrity should be implemented in Oracle? We are
starting a large new Java project. Our current applications keep their
referential integrity inside their own dictionary, so I haven't had to deal
much with referential integrity recently. Can there be too much of a good
thing?
Hi All,
I know I've seen this before but I forget ...
Given a table like
Customer_Software(
Custid Number
SoftwareVarchar
)
How do I return the customerid and all the software entries in a single
row?
Desired output is like
Custid
-
Hello Mogens,
TCH is the touch count.
Cheers
Connor
OT - enjoy JL's conference this week.
--- Mogens Nørgaard <[EMAIL PROTECTED]> wrote: > And
in 8i there's a column in x$bh which counts the
> number of times the
> buffer is touched (as I recall) called XNC or
> something?
>
> Rachel Carmic
On Mon, Jan 21, 2002 at 10:52:06AM -0800, [EMAIL PROTECTED] wrote:
> Tim,
>
> I've always chosen to just deal with the nulls rather than worry about
> padded strings or storing a single space. Personally I can't stand
> storing a single space to represent an empty string and prefer the null.
>
Its like one of the most common arguments against raw.
"Don't use raw since a sysadmin might mistakenly
create a file system over the top of it"...
... I've always thought thats an argument against
having a shoddy sysadmin rather than not using raw :-)
--- Mogens Nørgaard <[EMAIL PROTECTED]> w
This is sort of true. Steve's test will tell you what
you can currently achieve based on your current
system. File system and/or kernel restrictions may
limit what is actually possible on the platform.
eg a stock-standard newfs on Solaris will typically
limit you to 256k; playing with maxcontig
Our developers store XML docuements inside CLOBS and
want to search the CLOB contents based on a search
string. I have lot of concern about such queries but
could benefit from someone on the list who has already
solved the performnce issues with such searches.
Typical existing queries I have come
Thanks, Dennis, my boss is thinking HP already. As far as flavor of UNIX,
that wouldn't matter much. I'll have to learn it from scratch anyway.
Best regards,
Sergey
-Original Message-
Sent: Monday, January 21, 2002 3:25 PM
To: Multiple recipients of list ORACLE-L
Subject:RE
-Original Message-
Sent: Monday, January 21, 2002 2:41 PM
To: Multiple recipients of list ORACLE-L
The DBA has more responsibility, usually more experience (this usually
translates into higher pay as well) than Apps DBA.
Well, yes and no. I have seen many orginizations pay the Apps D
Considering I have a brand spanking new Sun box waiting for me in the Server
room, this thread has been less than comforting.
Not Stable?!? I am starting to miss my DG boxes already.
Steve
-Original Message-
Smith
Sent: Monday, January 21, 2002 7:00 AM
To: Multiple recipients of list O
OK, I give. Where's it hiding?
I'm sitting at the ftp site where I found the 8.1.7.2 patchset
server/patchsets/unix/SUN_SOLARIS2/81patchsets/32BIT
there's no 8.1.7.3 patchset there. (There's an 8.1.6.3, but no 8.1.7.3)
Any clues???
Thx!
Barb
> --
> From: A. Bardeen[S
Title: RE: DBA Vs Apps DBA
From past experience:
Many companies may classify a DBA as the person that administers the database and the Apps DBA to administer the applications that utilize that database.
The Apps DBA may be more of a glorified database developer with some DBA duties and unde
you HAVE to drop the tablespace. You do not have a consistent database,
and your database is a disaster recovery scenario waiting to happen.
The question is, why did you drop the datafile without researching the
ramifications?
--- Andrey Bronfin <[EMAIL PROTECTED]> wrote:
> no , and i can not do
Sergey - Sorry for the confusion. Our ERP system is Lawson and I somehow had
a brain fart and thought you were on that email list. If you management is
just thinking about Unix, then the last thing you want to do is scare them
off with an argument about which Unix. Start every reply with "of cours
When Oracle said Sun was not stable I do not think they meant that
in terms of running. I believe they mean that the libraries and what
not change to much. When you are trying to code to a particular OS
that can be annoying I guess. However, I am getting this not from Oracle
themselves so who r
Hi all,
I guess this question has been asked many times both in this list and
offline. I had promised to write this sometime back, so it's time to get
to the bottom of this:
History: Oracle has had an ERP (Enterprise Resource Planning) application -
simply named "Oracle Applications" - for a l
If you turn prompt off you do not get the question.
-Original Message-
Lee - lerobe
Sent: Monday, January 21, 2002 7:36 AM
To: Multiple recipients of list ORACLE-L
Is there a reason why you don't want to use the perfectly acceptable
mput/mget utilities provided with ftp ??
-Origin
Hamid Alavi wrote:
>
> List,
>
> I have some problem with Trigger, I want to Insert a record as Primary Key
> on each insert into Table1 and the same time create another Primary key in
> table2 plus PK from Tabl1 inserting in Table2 as Forign Key, Is there any
> way to do all these steps in one
shuli wrote:
>
> Dear listers,
> Could someone share his/her experience on partitioned IOT. I am quite
> confused now. I have an partitioned IOT. The performance of query data from one
> partiton of the partitioned IOT is worse than query data from the unpartitioned
> IOT.
> Any advice
Have you tried removing the "" from around the tablespace name?
Sona wrote:
> Hi
> i am trying to recover the database from the loss of SYSTEM datafile.
> After mounting the database ,I tried recovery using RMAN
> RMAN> run
> 2> {
>3> allocate channel c1 type disk ;
> 4> restore tablespace "sys
[EMAIL PROTECTED] wrote:
>
> Try,
> select col1 from table1 where col1 not in (SELECT col1 from table2)
>
Rha
--
Regards,
Stephane Faroult
Oriole Ltd
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City
Hi,
I tried to download Designer 6i from OTN, but I got:
Oracle Designer 6i Release 4.1.1 (Coming Soon)
Does anyone know where can I download release 4 or
release 3?
Thank you.
Andrea
__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail
I want to thank everyone for the input.
Best regards,
Sergey Babich
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
The developer updated me with the following information regarding this
problem:
'If I edit the inline view and removed the decode from the outer query, the
query works'
This update leads me to believe that this might be some kind of bug or
altered feature in 9.0.1 instead of some stupid permis
Can you elaborate on exactly what happened? 8.1.5 to 8.1.6 is just a
catalog script and a binary change. What error did you encounter, and
at which step in the upgrade? Extents should not matter in an
upgrade.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon, 21 Jan 2002, Dave Morg
Hi
i am trying to recover the database from the loss of SYSTEM datafile.
After mounting the database ,I tried recovery using RMAN
RMAN> run
2> {
3> allocate channel c1 type disk ;
4> restore tablespace "system";
5> recover tablespace "system";
6> sql 'alter database open';
7> release cha
Dale,
Thanks for your reply.
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dale Edgar
> Sent: Saturday, January 19, 2002 1:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Dat
Tim,
I've always chosen to just deal with the nulls rather than worry about
padded strings or storing a single space. Personally I can't stand
storing a single space to represent an empty string and prefer the
null.
Not all share my opinion obviously, but I've just gone along with
the trinary l
Try prompt before issuing the mget or mput command.
Terry
-Original Message-
Sent: 21 January 2002 14:55
To: Multiple recipients of list ORACLE-L
Hallo,
anyone whom can tell me how to write the ftp command if I want to receive
all files in the unix directory to the hard drive without
Hi,
On January 2 this year (for troubleshooting purposes) I imported a database
from one of our clients. The import was fine, except for a few objects that
did not compile. Since these objects were not part of our application and
did not appear to interfere with our application, we ignored them
List,
I have some problem with Trigger, I want to Insert a record as Primary Key
on each insert into Table1 and the same time create another Primary key in
table2 plus PK from Tabl1 inserting in Table2 as Forign Key, Is there any
way to do all these steps in one trigger and assign this trigger to
And I was worried about 20 to 60 extents. :)
But I do have one question, if a table has multiple extents, 20 extents at
1Mb each, and they are
contiguous, is that equal to 1 extent of 20Mb big ?? Does oracle have to
work harder to get
those 20 extents ? (okay two questions)
Darren
-Origin
Dear list !
Sorry for an ignorent question :
what's the difference (functional and technical) among Oracle pipes and
Oracle message queues ?
DBAndrey
* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
no , and i can not do so (it's a more than 1TB tablespace , i can't recreate
it = no time frame).
thanks !
-Original Message-
Sent: 21 January 2002 18:01
To: Multiple recipients of list ORACLE-L
did you drop the tablespace as well?
--- Andrey Bronfin <[EMAIL PROTECTED]> wrote:
> De
nope.
The file was physically
deleted at the OS level after "offline drop".
Thanks
DBAndrey
* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: 21 January 2002 17:51
To: Andrey Bronfin
esoft.com> cc:
Yep. Rested. That's me. A.
Thanks!
-Original Message-
Sent: Friday, January 18, 2002 4:11 PM
To: Multiple recipients of list ORACLE-L
Bambi,
Boy you ARE rested!!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bellows, Bambi
INET: [EMAIL PROTE
Check out the dbms_space package owned by system.
Dick Goulet
Reply Separator
Author: "Daiminger; Helmut" <[EMAIL PROTECTED]>
Date: 1/21/2002 7:35 AM
Hi!
I deleted several thousand rows from a table, but it looks like the table is
still taking up t
As a cost-cutting measure: They could combine the U.S. and European
conventions, all they have to do is hold them in Halifax ...
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Monday, January 21, 2002 11:56 AM
To: Multiple recipients of lis
Let me add the official stuff here.
Oracle has booked the Moscone Convention Center for the next 10 years. It
makes financial sense for them to have the conference in their home area.
Unfortunately, as hotel prices increase in San Francisco, the opportunity
for attendance by small organizations
Hi All,
Actually, in extreme cases ( >87000 in my case, and I had 12
tables
like that) it can cause problems with upgrading. Not sure what, but we
had to do CTAS into new tables with much larger extents to do the
upgrade from 8.1.5 to 8.1.6 here. Had Oracle support and consultants
baffled
Good point Kevin, maybe I should read the question more thorougly next time.
Apologies Roland, I believe there is a flag to run non -interactive (-i)
Cheers
Lee
-Original Message-
Sent: 21 January 2002 16:15
To: Multiple recipients of list ORACLE-L
I think he's asking about the turni
The tool hasn't been used against an SAP system as yet. Dale and I were
actually talking this through this afternoon (we've been out on site
together today), and recognise the importance of having extraction sets (you
may want to call them Knowledge Modules) already defined for people to
download
Dear listers,
Could someone share his/her experience on partitioned IOT. I am quite
confused now. I have an partitioned IOT. The performance of query data from one
partiton of the partitioned IOT is worse than query data from the unpartitioned
IOT.
Any advice would be greatly appreci
Hi Jared
> Do you know if anyone has successfully used this tool
> on an SAP database? That would be *truly* impressive.
No, there has not been a SAP implementation. There is no reason why DataBee
could not do it though.
We would be willing to work closely with someone (and provide a free copy
These threads always crack me up. Its like religious wars.
We've got both in house. Most of my stuff runs on the SUN boxes, and I
have had no problems with the stability. I guess administration of the
HPs is easier, but the Sun SAs aren't complaining so its pretty much a
non-issue for us. As f
I am terrible with database links. We are having a problem with a link
from a 9.0.1 database to an 8.0.4 database.
Following is the problem:
(Embedded image moved to file: pic16827.pcx) Full Description:I am
trying to run a SQL query with an inline view (see below) in
Rene,
Following on from below (can you explain more - such as any errors received)
you may want to also look at upgrading your box. For a start your processor
may have a little work to do with Oracle as it's only a 233, but you should
first look at the memory available. I believe that Oracle reco
We are trying to install Oracle 8.1.7 on Compaq Tru64 with 0.S. 4.0F with
the latest patch kit, and the EV5.6 chip set. The install just bombs off at
56% complete. No error messages, log messages, or trace files (hasn't gotten
far enough to create ORACLE_HOME). The install works fine on another ma
Hi Willie,
Maybe your dateformat isn't correct. You should check the NLS Parameters.
regards
Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: Townsend Willie [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 21. Januar 2002 16:15
An: Mult
You have gone about a totally wrong way of dropping the datafile. To drop a
datafile from a
tablespace, u have to export the tablespace by taking a series of user
exports in that tablespace,
dropping the tablespace, deleting the datafile at the OS level, recreating
the tablespace with the
proper
Oracle OpenWorld in the Americas will never leave the West Coast and is
highly unlikely to leave San Francisco. Too convenient to Headquarters
If Miracle gave that class in Halifax, I'd go!
--- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote:
> May I suggest Halifax, Canada as a great location for
Sundeep,
The biggest problems you'll have is 1) GETTING THE DEVELOPERS TO AGREE, and
2) your having to write all those procedures.
In general I prefer a mixed bag approach. If all their trying to do is
select, insert, update or delete a single row in a simple statement, then who
cares.
you enter the command prompt, to flip the switch, then mget *, or mget
*, or *. For UNIX, using SmartTerm, I use the ftp drag &
drop tool.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Monda
This is very easy, the only one that you have tu put with the ftp session open is:
ftp > prompt
You will see a message :
Interactive mode off.
after that you write the mget or mput *.* and thats all.
[EMAIL PROTECTED] wrote:
> Hallo,
>
> anyone whom can tell me how to write the ftp command
did you drop the tablespace as well?
--- Andrey Bronfin <[EMAIL PROTECTED]> wrote:
> Dear gurus !
>
> I have an "offline dropped" datafile at my database. The file was
> physically
> deleted at the OS level after "offline drop".
> Before dropping the file , all the objects that had extents allo
Hello all,
My 2 cents' worth:
Far too much time is spent by a number of users in the Oracle List sending
e-mail of no worth whatsoever. Half the msgs I read are what charitably
might be called 'chat'. I understand that there is an off-line site for
'chat' - why not use it and stop mucking up the
In NT there is a -i switch for ftp that will get rid of the prompts.
Don't know if its available in unix.
-Original Message-
Sent: Monday, January 21, 2002 9:55 AM
To: Multiple recipients of list ORACLE-L
Hallo,
anyone whom can tell me how to write the ftp command if I want to
receiv
when you connnect through ftp i always use
ftp -inv servername
that stop you from having to enter Y after each file
-Original Message-
Sent: Monday, January 21, 2002 9:55 AM
To: Multiple recipients of list ORACLE-L
Hallo,
anyone whom can tell me how to write the ftp command if I want
Maybe it's because the SSTIOMAX constant. On 7.3 that
value was 128k. From 8.0.5 has been raised to 1m.
Regards.
--- "Boivin, Patrice J" <[EMAIL PROTECTED]>
wrote:
> Ok, I successfully ran it against another database
> on the same server.
>
> The maximum effective db_file_multiblock_read_count
>
I think that the last line is the problem and that you have to change it to
AND D1.EFFDT <= TO_DATE('01-JAN-2002', 'DD-MON-'));
I think that he is converting D1.EFFDT to char-format instead of converting
'01-JAN-2002' to date-format.
Best regards,
Marco
-Oorspronkelijk bericht-
Van
I think he's asking about the turning the "prompt" off...try typing "prompt"
before using the mget/mput commands.
-Original Message-
Sent: Monday, January 21, 2002 10:36 AM
To: Multiple recipients of list ORACLE-L
Is there a reason why you don't want to use the perfectly acceptable
mput
AH YES, PeopleSoft Security Trees, much fun!!
I believe you may be getting a row returned, but that row is a blank. Try
SELECT nvl(rtrim(SETID),'*'),
EFFDT
FROM PSTREEDEFN D
WHERE D.EFF_STATUS = 'A'
AND D.TREE_NAME = 'DEPT_SECURITY'
AND D.EFFDT = (SELECT MAX(D1.EFFDT)
FROM PSTREEDEFN D1
WHERE D
Try to enter the ftp command named prompt,
with that, you can toggle asking on and off.
HTH
Andreas
> --
> Von: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> Gesendet: Montag, 21. Januar 2002 15:55
> An: Multiple recipients of list ORACLE-L
> Betreff: Ftp command
>
>
Not yet,
I will do it immediately.
Thank you.
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, January 21, 2002 4:40 PM
> Bunyamin,
>
> ...your second question:
>
> If you have 8GB of RAM, I assume you are using Windows 2000 *Advanced*
> Se
Love is all you need.
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> or, of course, the answer to life, the universe and everything is?
>
> --- Jared Still <[EMAIL PROTECTED]> wrote:
> >
> > If the question is "Which episode of Star Trek was 'The Trouble
> with
> > Tribbles'", then yes. ;)
Hi,
use the "-i"flag. This turns off interactive mode
I believe you can also use the command "prompt" at the ftp prompt
Jack
[EMAIL PROTECTED]@fatcity.com on 21-01-2002 15:55:22
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
At the ftp prompt, type the wordpromptin the following way :
ftp> prompt
Hope this helps,
Samir
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax
Has anyone seen anything similar to the following:
After Installing SQL*Backtrack on a Solaris 2.6 box, one of the databases
on that box started coming down with 7264 errors a couple of times
a week. This is an 8.0.5.2.1 database and it is not the database being
accessed by SQL*Backtrack.
In
Hi,
Here is a script that will do what you want. Just fill in the appropriate values
for the first 5 environment variables and it should send all your files to the
appropriate place without you having to be prompted for each file.
DEST=machine
LOGIN=yourid
PASSWD=yourpasswd
FROMDIR=fromdir
Title: How to find out free space below High Water Mark in table
Hi!
I deleted several thousand rows from a table, but it looks like the table is still taking up the same amount of space in the tablespace. Which it indeed does, because delete does not reset the HWM.
Does anybody o
Is there a reason why you don't want to use the perfectly acceptable
mput/mget utilities provided with ftp ??
-Original Message-
Sent: 21 January 2002 14:55
To: Multiple recipients of list ORACLE-L
Hallo,
anyone whom can tell me how to write the ftp command if I want to receive
all fi
1 - 100 of 139 matches
Mail list logo
