(jobnbr, sourcefiscalyear)
using index tablespace index73
pctfree 5)
/
Check the length of the constraint name. I don't know what the
limitation is (I haven't looked), but I recall having a similar problem,
so I just shortened the name.
Gary Chambers
Gary Chambers
//--
// Lucent Technologies ITO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gary Chambers
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gary Chambers
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
the braindead obvious. Sorry for the noise.
Gary Chambers
//--
// Lucent Technologies CIO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
that, for the moment, contains only
textual data (not that it really matters, anyway). I don't understand
the relation of the textkey to the table.
TIA!!
Gary Chambers
//--
// Lucent Technologies CIO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road
it!! ;)
Gary Chambers
//--
// Lucent Technologies CIO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
of
Oracle?
Gary Chambers
//--
// Lucent Technologies CIO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
] O'Reilly Programming the Perl DBI book.
Gary Chambers
//--
// Lucent Technologies CIO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
-based application which allows for many
points-of-contact (e.g. SysAdmin, Apps, Network, etc.), but allows only
members of a particular group to modify certain sections of the record.
Any help will be greatly appreciated!
Gary Chambers
//--
// Lucent
-based application.
I have implemented a workaround by selecting a row from dual X number of
times. I wanted something a bit cleaner, and [seemingly] less
database-intensive than querying in a loop.
Gary Chambers
//-
// Lucent Technologies GIO/Unix
// 4
suggestions?
Gary Chambers
//-
// Lucent Technologies GIO/Unix
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//-
--
Please see the official ORACLE-L FAQ
though
of a bulk collect into an array of numbers?
It seems kludgy to me to have a table of n-rows of dummy data to grab a
specific number of values from a sequence. Is this a common practice?
Gary Chambers
//-
// Lucent Technologies GIO/Unix
// 4 Robbins Road
All...
Is there a method by which I can select the next x values from a
sequence from dual? I've searched Google and OraFAQs.com, but I can't
seem to make any hits on my search request. TIA
Gary Chambers
//-
// Lucent Technologies GIO/Unix
// 4 Robbins
to
reverse engineer a database.
Gary Chambers
//-
// Lucent Technologies GIO/Unix
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//-
--
Please see the official
Has anyone used an Windows ssh client in a large environment (50 +/-
Unix servers, 300+ instances) that they would recommend?
SecureCRT at http://www.vandyke.com. $50.00/license for 200 to 499
users.
Gary Chambers
//-
// Lucent Technologies GIO/Unix
// 4
vs. singular table names?
Gary Chambers
//-
// Lucent Technologies GIO/Unix
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//-
--
Please see the official
All...
Will some of you please provide some insight on your table naming
conventions? I'm in the very early planning stages of what will likely
be a large and complex schema (IT asset inventory). I have a chance to
start it correctly. TIA
Gary Chambers
baffling and frustrating. Some of these folks claimed to have 5 years
experience!!!
Unfortunately for most everyone, the only people that benefit from most
certification programs are the facilitators. They're cash cows for
the purported issuers of such certifications.
Gary Chambers
um, I'd schedule step 6 AFTER the backup finishes... I've seen idiot
SA's who start the backup then shutdown the machine or kill the
process before it completes.
Yeah? And there's a good reason we SAs keep root privileges away from
you DBAs. :-))
Gary Chambers
hey - who is this SA and what is he doing here? this is where us'n
DBA's get to trash everybody else. go away!
I come in peace -- honest!!! I'm an aspiring DBA, and I want to do
it the right way... How's that? :-))
Gary Chambers
//-
// Lucent
of examples. :)
Gary Chambers
//-
// Lucent Technologies GIO/Unix
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//-
--
Please see the official ORACLE
by the use of aggregate functions in my query. I can provide
examples of my failed attempts, if you'd like. Thanks in advance for
any assistance you can provide.
Gary Chambers
//-
// Lucent Technologies GIO/Unix
// 4 Robbins Road, Westford, MA 01886
// 978-399
23 matches
Mail list logo