was installing Standard
Edition.
Both problems resulted in the message of 'not connected to oracle'.
Come to think of it, I don't think I've ever had a version of the DB Creation wizard
work without getting some error.
--
Alan Davey
[EMAIL PROTECTED]
718-482-4200 x106
On 3/11/2003 12:44 PM, Stahlke
You could also do it as part of your insert statement if you didn't want to use a
trigger.
INSERT INTO employees
VALUES (employees_seq.nextval, 'John', 'Doe', 'jdoe',
'555-1212', TO_DATE(SYSDATE), 'PU_CLERK', 2500, null, null,
30);
Same thing goes with currval also.
--
Alan Davey
VALUES (employees_seq.nextval, 'John', 'Doe', 'jdoe',
'555-1212', TO_DATE(SYSDATE), 'PU_CLERK', 2500, null, null,
30);
Same thing goes with currval also.
--
Alan Davey
[EMAIL PROTECTED]
718-482-4200 x106
On 3/10/2003 3:49 PM, DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Has anyone defined
If you are taking the 9i certification, there are only 4 exams that you have to take.
Unfortunately, unless you took at least one exam last year and got grand-fathered,
you will have to enroll at Oracle U. for one of the four courses covering the
certification exams.
--
Alan Davey
[EMAIL
Why not just have Connection B trap the Unique Constrait Error and branch to some
different code? What would Connection B have done if it had found the record where
id=1?
--
Alan Davey
[EMAIL PROTECTED]
718-482-4200 x106
On 2/24/2003 2:49 PM, Rick Stephenson [EMAIL PROTECTED] wrote:
OS
For $500 you can build your own Intel/AMD machine with 1GB of RAM that will blow the
doors off the Sun Ultras. You may need to spend a little more if you need some hard
drives and a cheap video card.
Install Linux, Oracle and enjoy.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 1
Beer Pong is a lot of fun too. ;^)
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 1/30/2003 10:09 AM, Gogala, Mladen [EMAIL PROTECTED] wrote:
We would not be able to feed our families on our physical abilities
but I definitely would try beating Lisa in the game of Ping Pong
Why do they want to move to W2k? Was it running too quickly for them under Unix? ;^)
You can use export/import to move the database. Hopefully the database isn't very big.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 1/29/2003 12:59 PM, Baswannappa, Shiva [EMAIL PROTECTED] wrote
Hi Lyndon,
Well I don't know about your setup, but I can connect just fine with the connect
string you listed below on Win2K, Oracle 9.2.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 12/4/2002 2:09 PM, Lyndon Tiu [EMAIL PROTECTED] wrote:
This is unfortunate or maybe just it's just
User Agreement, it says that they have the right to send an email
greeting to everyone in your Outlook Address Book if you use their software. I didn't
bother to install beyond that point.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 11/25/2002 1:51 PM, [EMAIL PROTECTED] wrote:
What
I get the same date for Oct 5 - 15 (10/15/02).
Good thing I don't deal with dates that far back. ;^)
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 11/22/2002 12:55 PM, Freeman, Robert [EMAIL PROTECTED] wrote:
Don't believe me?? Try this:
create table test(the_date date);
insert
Very tricky Robert. ;^)
Spoiler Alert below!!!
After some time to think about this, I did a quick search on Google and realized that
this is when the calendar changed from Julian to Gregorian.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 11
Hi,
Why not just use the replace function?
select replace('Line1'||chr(10)||'Line2',chr(10),' ') from dual
select replace(my_string,chr(13)||chr(10),' ') from my_table;
HTH,
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 11/18/2002 7:18 AM, John Dunn [EMAIL PROTECTED] wrote:
I want
Well with the ridiculous salary they are offering, they could at least train you in
the use of SAP. This is a Fortune 500 company after all.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 11/6/2002 10:56 AM, Paulo Gomes [EMAIL PROTECTED] wrote:
unfortunatly i don't work with SAP or i
('127.0.0.1',INSTR('127.0.0.1','.',1,3)+1,LENGTH('127.0.0.1')-INSTR('127.0.0.1','.',1,3)+1)
FROM DUAL
There may be a more elegant solution, but this was the quickest I could come up with.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 10/16/2002 4:32 PM, Johan Muller [EMAIL PROTECTED] wrote
far
everything is working great.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 9/26/2002 12:33 PM, Hemant K Chitale [EMAIL PROTECTED] wrote:
Well, yes, that is one option. Can I issue an ALTER TABLE table
MOVE to
the same tablespace, I wonder.
Thanks
Hemant
At 08:23 AM 25-09-02
Hemant,
If I understand your question correctly, trying using the alter table move command and
specify new values for pctfree and pctused. This should affect existing blocks. Make
sure to rebuild any indicies.
HTH,
--
Alan Davey
[EMAIL PROTECTED]
On 9/25/2002 11:38 AM, Hemant K Chitale
(not in the where clause)
I've seen it mentioned to use bind variables when comparing a column to a literal in
the where clause, but nothing specific about the above scenarios. Basically what I am
asking is, do all literals need to be made bind variables?
Thanks.
--
Alan Davey
[EMAIL PROTECTED
Karthik,
You need to rebuild your indexes after moving your table as they are invalidated with
the move.
HTH,
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 9/17/2002 10:03 AM, Karthikeyan S [EMAIL PROTECTED] wrote:
Thomas / Amar,
I moved the tables from SYSTEM to the DATA
which table was locked.
I was hoping to find the offending SQL statement.
Have a great weekend everyone.
Regards,
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 8/29/2002 10:43 PM, Rachel Carmichael [EMAIL PROTECTED] wrote:
I'm not sure it's possible to find the locking SQL and SID once
Thanks Raj.
I'll give these a try.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 8/30/2002 10:08 AM, Jamadagni, Rajendra [EMAIL PROTECTED] wrote:
I created following two views for developer's use and so far there
have been
no complaints ..
CREATE OR REPLACE FORCE VIEW SYSTEM.DB
if there had been multiple DML
statements by this user, how would I know which was the first/last one executed?
I'm RTFMing, but so far no luck. Any help would be greatly appreciated.
Regards,
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
--
Please see the official ORACLE-L FAQ: http
Hi,
I've been hearing some good things about FrontBase:
http://www.frontbase.com
However, I haven't had time to experiment with it myself.
It is runs on Windoze, *nix and Mac OS X.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 8/2/2002 8:58 AM, Daniel Wisser [EMAIL PROTECTED
So no one responded with, We use raid xx. We don't have to worry about
backup/recovery. ;^)
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 7/22/02, mkb [EMAIL PROTECTED] wrote:
Ok, I need to vent a little.
Last week, I was asked to do some tech interviews over
the phones for a mid
, which I've found to be pretty reliable. If
you open My Computer (or explorer) you should see a folder called Scheduled Tasks.
Double-click and then use the wizard to set up a call to your batch file.
HTH,
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 7/17/02, Farnsworth, Dave [EMAIL
, but I don't see any caveats about indicies when using the move
option. So, am I safe in assuming that I don't need to worry about them?
Thanks,
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alan Davey
INET: [EMAIL
Thanks to all who replied.
Fortunately, the tables are relatively small, so the rebuild of the indicies shouldn't
take very long.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 7/9/02, Jack Silvey [EMAIL PROTECTED] wrote:
Alan,
The alter table move command will invalidate all
Beware of developers that carry screwdrivers.
Its a hardware problem, not software.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 5/30/02, Thomas Day [EMAIL PROTECTED] wrote:
I guess it's that old Russian proverb To a hammer, all the world
looks
like a nail. Developers have
On 3/20/02, Mark Leith [EMAIL PROTECTED] wrote:
Ahh, but how can you be sure that 42 does not also *cause* all of
life's
problems? ;)
Because, as Homer Simpson said, Ahhh booze. The cause of and the solution to all of
life's problems. ;^)
--
Alan Davey
[EMAIL PROTECTED]
On 3/20/02, Mark
29 matches
Mail list logo