RE: MIcrosoft Blackmail

running Samba) with an RH or SuSE sitcker on it next to the NT boxes on your rack. See if that helps them understand your point of view... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647

Re: rebuilding an instance from a cpio file?

with the syntax to list out the contents of the cpio file? man 1 cpio; cpio -it $inputfile; # short listing (like ls) or cpio -itv $inputfile; # verbose listing (like ls -l) -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL

RE: Here we go again!!

at the HTML they generate today. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven

Re: No space left on device - but I have lots left.

-- ltiu [EMAIL PROTECTED] The error messages are very informative don't you think? Error messages in most products stink. If you don't learn to outsmart the developers and find what's wrong you will never be able to manage databases or operating systems. -- Steven Lembark

Re: off-topic -UNIX question

., linux, Solaris) you can look for /proc/$id. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Re: Unix Question

in /var/tmp because that needs to be changed. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: arg list too long in unix

can be expensive in a 10 000 file diredtory; find does not sort anything and is better suited to dealing with huge file lists. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1

Re: arg list too long in unix

I cant list them using ls -ltr *session* as this string may change. I have to identify the files that srart with cz only. can somebody through somelight on this. man xargs; -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL

Re: arg list too long in unix

. Other problem with using ls for large file op's is that it attempts to sort the output, which is expensive and a memory hog. Find simply spits out matching files as they are found. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL

RE: arg list too long in unix

of more forks). Aside: be quite sure to run this on local storage only; running this on networked storage can saturate the network during the erase cycle. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647

RE: Unix question: how to display SID and path in prompt

equivalent to most *NIX shells w/ the added benefit of lexical var's. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http

RE: Unix question: how to display SID and path in prompt

of us are on *NIX :-) -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark

RE: Unix scripting need help

-- [EMAIL PROTECTED] echo $all_file | sed 's/mylogfile//g' | sed 's/\.log//g echo $file | sed 's/[^0-9]//g' avoids problems if someone decides to add a dash or sometning into the name. -- Steven Lembark 2930 W. Palmer Workhorse Computing

Re: Unix scripting need help

File and number: $_, $i\n; } -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Re: Unix question: how to display SID and path in prompt

Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City

Re: Unix question: how to display SID and path in prompt

escape sequences for PS1: \u = user \h = host \W = basename( $PWD ) \$ = '#' if SU else '$'. so: PS1='\u@\h:\W \$ '; gives username@hostname:dirname $ for normal users or ending with '#' if you are SU. -- Steven Lembark 2930 W. Palmer Workhorse

RE: Unix question: how to display SID and path in prompt

. enjoi. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL

RE: Data Warehouse on Windows -more

=y # CONFIG_HIGHMEM4G is not set # CONFIG_HIGHMEM64G is not set -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ

Re:Hot Backup using EMC /BCV splits

but at least worked. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 ## # # $Author

RE: Hot Backup using EMC /BCV splits

in Oracle, probably still is) I had to copy them onto the local system and then feed a local filename into svrmgrl. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582

RE: Oracle Arm Twisting?

, Cancel the contract and renew it with a different number of users. Once the old contract has expired and is no longer in force you are not changing the number of users since it is a new contract. It may be that playing hardball is the only way to get their attention. -- Steven Lembark

Re: what is wrong with this idea ...

there but properly normalizing the data will do a better job. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http

RE: Oracle Arm Twisting?

Open Source software has been catching on is that people get sick of licensing issues. I am not advocating that you dump Oracle for Postgress, but this is a good example of what makes people think twice about using OS when it does meet their needs. -- Steven Lembark

RE: Oracle Arm Twisting?

up licensing fee just about matched the restart fee? -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http

RE: Oracle Arm Twisting?

is selling you if you think their support is that bad: fear of not having support that you don't want because you think it's bad. Q: Does anyone know of any reliable 3rd party support for Oracle? -- Steven Lembark 2930 W. Palmer Workhorse Computing

Re: Why use a Unix Pipe to uncompress a file?

to the disk causes much more kernel overhead than spitting the data into a pipe; savings there is time and overhead (leaves more cycles and I/O bandwidth avilable for other proc's running on the box). -- Steven Lembark 2930 W. Palmer Workhorse Computing

Re: Oracle vs. DB2

One thing that seems different to me: DBA's at the sites we work in with DB2 seem to swear by it more than at it. This is the reverse ratio I find at Oracle houses. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647

Re: It took more than an hour to update 10,000 records

about using a language that supports place holders (e.g., DBI) or turning on cursor sharing so that the optimizer isn't called for each iteration? -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647

Re: Perl and Oracle

Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City

Re: Unix Script Quest : Urgent

. The perly code will give you finer control and better sanity checks (e.g., comparing to a list in memory of what has already been found to avoid dup's) than find can. enjoi. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647

Re: Establishing policies, standard operating procedures, and

+Hand bookAuthor=Nemeth -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark

Re: partition tables

(though with more rows than this, the count of partitions helped). A lot of it comes down to how the primary key breaks down and how granular the rolloff needs to be. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647

Re: so when did you switch from NT to unix for oracle

of *NIX debates, linux is proving out as a nice, stable platform for cheap, reliable federated systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see

Re: joining word/ lines in a file

information (like subscribing). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark

Re: joining word/ lines in a file

). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED

Re: joining word/ lines in a file

$/;($a=ARGV) =~ s/\n+/ /g;s/ +/ /g;print $a' ... will convert nearly anything you can give it into a nice, clean, single line. If you want to get things neater than this see the examples in Parse::RecDescent. -- Steven Lembark 2930 W. Palmer Workhorse Computing

RE: joining word/ lines in a file

specifier (undef $/ for slurp mode). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Re: RedHat

. If you need speed, Mandrake is probably a better bet. Information on linux in general and the varous distro's are available at www.linux.org, www.redhat.com, www.tummy.com, or under varous points on your favorite search engine. -- Steven Lembark 2930 W. Palmer

RE: Do you ever have days where you dont want to think ?

isn't high enough oracle will skip it anyway. Try an analyze table first on the exists (or a sub-query) and see how that works. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1

Re: Storing phone info...

on these are usually a waste (not specific enough) but for a count(*) by a/c it beats having to substr the entire thing. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582

Re: Compressing Export Dumps

*1024)) date +dump-%Y%m%d; Gives a set of 1GB files as output. Simpler to manage since they all have the same size (whatever you set -b to) w/ a runt file at the end. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647

Re: offtopic - unix command

Is there a way to check for the success/failure of the actual remote command when using rsh? $a=$(rsh blah); and parse $a for output for an indication of the blah command succeeding or failing. -- Steven Lembark 2930 W. Palmer Workhorse Computing

Re: Need Script to Trigger Archive Log Cleanups

. That or pass on a was clean message and change the array to results or something. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 diskfrie Description: Binary

Re: offtopic - unix command

in something that does output a reasonable message (or re-write it to do so if you have any control). If the command has neither verbose mode nor any useful messages by default then give its programmer 30 lashes w/ a wet noodle for designing undecipherable code. -- Steven Lembark

Re: offtopic - unix command

but depend on shell-specific syntax. Using a #! file on the remote end is a bit safer and allows for comments in the code. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762

RE: News.

certianly not going to run around in the streets naked celebrating over the news [for which my neighbors are lucky] but it is worth noting and is probably pleasant news for most of us. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL

Re: Telephone Alerts

things. Other approach is to use an email account and MIME::Lite to send the messages. Given the addresses you can phone, page, or just mail people. Trick is to keep the message short (e.g., Call Jow Bloe +1 234 567 8900\n\nfoobar database has blah\n). -- Steven Lembark

Re: data warehousing desing - to denormalize or not to denormaliz

totals) on a monthly basis, leving monthly aggregate values online for perhaps 24 months. The delete cycle is less painful in a -- much smaller -- data mart than the whole warehouse and leaves users able to make the buisness-cycle queries they need. -- Steven Lembark

Re: Raw device backup script

' of='$ENV{TAPE}' obs='$blocksize'}; mt 'eof'; } # avoid cinches in the tape and make sure not to overwrite # a valid backup with a new one if someone forgets to change # the tape. mt 'retension', 'rewoffl'; # this isn't a module 0 __END__ -- Steven Lembark

Re: Unix questions - Please advice

for authentication -- a big timesaver on networked file systems or ones with advanced security hacks. You can also run xargs w/ multiple proc's, which allows the latency of one proc's to be used up on another (see the --max-proc option to gnu xargs for an example). -- Steven Lembark

Re: Cronjob

to handle lookups. Main advantage is giving you a single point to track the results -- instead of having to deal with all of the /after options and separate jobs. With Schedule::Cron you can feed in a crontab file or use $cron-add( $schedule ) to generate the jobs w/in your code. -- Steven Lembark

Re: How to simulate Block Corruption?

40KBytes of corruption. If your dd has offset capability then use it to simulate corruption at various points in the file. to simulate corruption in expanding the file use: dd if=/dev/urandom bs=8k count=$howevermany $yourdbf; -- Steven Lembark 2930 W. Palmer

Re: Root Cause Analysis White Papers

would be a good place to start looking at what is done on the systems, what goes wrong with them and where to look further for root causes. Audit results also give you the facts you'll need in convincing the manglement that something really is wrong and it needs fixing. -- Steven Lembark

RE: How Oracle screwed California

-- Boivin, Patrice J [EMAIL PROTECTED] I don't know if Microsoft negotiates -- do they negotiate? Quite. They make Norton Simon look like a pushover. See coverage of the recent trial for examples. -- Steven Lembark 2930 W. Palmer Workhorse Computing

RE: Number of CPUs vs. Speed of CPUs

for rollback and lock management. It isn't very hard to get constipated disk systems w/ SPM and Oracle. You also end up with a major bottleneck at the bus controller on most systems. Paged I/O and disk commands can easily strangle the system. -- Steven Lembark 2930 W. Palmer

RE: MySQL vs. Oracle database

Oracle. For load+query (a.k.a., warehouse) operations it can be faster than Oracle because it doesn't get tangled up with rollbacks, etc. On systms with many instances it also can be much simpler to administer. -- Steven Lembark 2930 W. Palmer Workhorse Computing

Re: Developer access in test database

on an updated config file or some standard notation for the alteration to the DBA's. Otherwise you just get a barrage if semi-cohereint emails asking for minor changes. enjoi. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647

Re: Slightly OT: Perl Q.

logic in perl anyway. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark

Re: Connecting to Oracle via Perl

to (see the DBD::Oracle manpages for examples). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: Convertion from Figures to Words

this already in the Lingua:: group on CPAN. Hit up www.cpan.org, choose module search and look under that heading. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582

RE: Oracle Wants Users to Hand over Apps Management

and systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL

Re: .dbf is a valid name for a datafile name?

you're done with it. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark

Re: Linux for Big(ish) Databases

We've got a new database to put together. OLTP, 100-200 users, ~250Gb data. We haven't decided on a platform for this yet. Is Intel/Linux worth considering for this size of thing? No reason why not. Might also want to consider linux on a Sparc or Alpha. -- Steven Lembark

Re: Unix Book

Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City

RE: What tools for Oracle Data Warehouse ETL

such a kind of tool. Ideally you'd want to avoid sql-loader like the plague and have the product load directly. Every project I've been on that used Oracle's loading software got bottlenecked to the point of severe pain. -- Steven Lembark 2930 W. Palmer Workhorse

Re: Ang: Re: Unisx question

Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City

Re: newfs suggestions for Oracle filesystem

use from the default to 100%. This will keep the files a bit more contiguous. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L

Re: Off-topic Perl Question

of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762

Re: HP vs SUN for a UNIX box

(neither is Sun's but gcc handles Solaris its lib's better). You also have more control over the file system. Combining larger file system pages w/ appropraite striping can give you a nice boost in performance w/ RAID sytsems. -- Steven Lembark 2930 W. Palmer Workhorse

Re: Why metastink {or fetidstink !} ??

archetecture isn't *that* complicated either. Applying one or both of these would probably reduce the monikers. Hell, they might even make people happy... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647

Re: OT: Restricting Copy Operation

the execution and then perform some sort of copy operation on the local box (where the mods no longer apply). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see

Re: Data Archiving

to be a Platinum Tech. product. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark

Re: retrieving objects usign OCI

::OCI on CPAN. It is a Perl interface to the OCI lib's by the same gent who wrote DBI and DBD::Oracle. It has plenty of examples -- both from the internal code using OCI and the Perly interface. -- Steven Lembark 2930 W. Palmer Workhorse Computing

Re: Create a database without using DbAssist

from Oracle on the install and manglement side seems pretty heavily weighted towards if you use the menus everything works so just use the menus. At that point mailing lists like this one may be the last place people can turn for legit answers. -- Steven Lembark 2930

Re: RAID system max throughput

a hit writing extra data to maintain the RAID5 parity. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: OT: perl q

way you did in ksh (with reasonable variables and control structures added) or use dbi to feed the commands directly into the server. You might want to check out the [EMAIL PROTECTED] mailing list or CPAN for working examples. -- Steven Lembark 2930 W. Palmer

Re: Anybody heard Oracle will remove the JVM from Oracle in future

-- Scott Shafer [EMAIL PROTECTED] Haven't heard myself, but I hope this is true. Please, please, please let it be true! Unlikely they'll actually dump java. If Oracle would simply SUPPORT DBI it'd be worth something... -- Steven Lembark 2930 W. Palmer

Re: Anybody heard Oracle will remove the JVM from Oracle in

in VB would be faster and far more user-friendly. DBI is your friend :-) Now that they've combined svrmgrl into the sqlplus engine there isn't anything you can't do through DBD::Oracle (or the shell if really necessary). -- Steven Lembark 2930 W. Palmer Workhorse

Re: Anybody heard Oracle will remove the JVM from Oracle in future

on why DBI isn't handling the placeholders properly or can't execute a database startup. Are they going to work through a solution or just tell you to email the dbi list? Or has anyone tried this and gotten some sort of result yet? -- Steven Lembark 2930 W. Palmer

Re: Anybody heard Oracle will remove the JVM from Oracle in

almost run itself. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET

RE: VMS equivalent of ls -lrt

do with them. Much appreciated Check the Big Grey Wall for the lexical func's in DCL (f$foo). They are processed in the second -- lexical -- phase of DCL processing and give you access to most of the guts of VMS. -- Steven Lembark 2930 W. Palmer Workhorse Computing

Re: Linux client error

. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED

RE: Operating Systems

Might want to look at RH Linux and get a subscription to the KRUD patch service (see tummy.com). RH certianly isn't perfect but is realatively easy to get help on and has plenty of extenal documntation and tutorials written for it (e.g., www.ora.com/linux). -- Steven Lembark

Re: Oracle software on RAID 5

will avoid data loss in the event of a disk failure. It will not allow you to keep running as though the disk had not failed; only mirroring allows that. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647

Re: Last day of the month unix

for UnixDate( 'tommorrow', '%d') == 1 ? 'last day of month', 'not last day'; -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ

Re: Replacing a Disk on WinNT

-- and copy the contents of the old drive to the new one. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http

Re: Data Cleansing.

-- Yuval Arnon [EMAIL PROTECTED] Hi, We are currently looking into a tool that will help us validate data (. Can you recommend any tool or product that will do it in an Oracle environment. Perl. Ab Initio (www.init.com) -- Steven Lembark 2930 W. Palmer

Re: Can Oracle and Sybase co-exists in a same Unix Box?

with it might be cheaper to simply lease a second machine for one year. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http

Re: Oracle 8.1.7 on Solaris vs. Linux

linux.org. They have a variety of success stories that include information on specific setups. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647

RE: ORACLE VS. SYBASE

of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W

Re: Physical access to servers for maintenance

been forced to do that the DBA should have done for themselves at 3am... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762

RE: looking for a parsing script

and generate a list of the tables, views and synonyms that are referenced. I was hoping someone might already have such a script. DBI might prove simpler for this via regexen or Parse::RecDescent. -- Steven Lembark 2930 W. Palmer Workhorse Computing

Re: Datatype

-- Ken Janusz [EMAIL PROTECTED] Is there an Oracle datatype of DATETIME? I can only find DATE in my documentation. Yes, we have no bannanas: You get to split fields into Date and Time components in Oracle. Alternative is to use time_t and num(10). -- Steven Lembark

Re: How to move a databse from Solaris to Llinux

-- Reinhold Wagner [EMAIL PROTECTED] This means i have to do an export/import! Yup. If you have sufficient disk+cpu capacity you can export and import multiple tables at once, if the database is partitioned you may be able to unload multiple partitions at once. -- Steven Lembark

RE: How to organize oracle directories in Unix ?

likely be grouped onto devices that can gracefully handle the average flow. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800

Re: How to organize oracle directories in Unix ?

striping across multiple devices. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ

Re: How to organize oracle directories in Unix ?

idea as to how the filesystem maps onto the load. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see

Re: download 9i for linux

unzipping (i.e., it was an archive of items that didn't zip). The code extracted via gzip -dc blah | cpio -idv; -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647

RE: Interesting News..

with it. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http

Re: awk, sed, windoze, sql*loader, other fun stuff

DBI also. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http

  1   2   >