Search results for query: *

Can anyone give me any feedback on prior experience with you all doing this? Performance, stability, etc? Thanks! JE

has anyone worked with getting ASP to talk to a mainframe? if so, could you point me to good documentation. Thanks! JE

How can I split the following into separate columns? COLUMN A ----------- DOE, JOHN A DOE, JANE I'd like it like this COLUMN B COLUMN C COLUMN D -------- -------- ------ DOE JOHN A DOE JANE I've been using this for the firstname...

A couple questions: 1) Any got a huge warehouse (365 days with approx 8 million records per day) that have some GUI record retrieval built around it? 2) Is there a method to retrieve records from a binary file loaded into database, if so, is there a way to do even a query into that file...

this is put into a loop that gathers stats against partitions... dbms_stats.gather_table_stats( ownname => 'ABC', tabname => 'TABLEA', partname => prtn_rec.partition_name, estimate_percent => 0.1, block_sample => TRUE, cascade => TRUE); Any idea why it...

I have RMAN failing on 10g on doing an archive. Archive log is on, how can i disable this. Thanks for any help.

If a system is part of an ORACLE RAC configuration, is it possible to add another instance to that same box?

How can i get sets of duplicate data? For example, I have the following data in a table. 12312 DATA1 DATA2 12323 DATA1 DATA2 33333 DATA3 DATA1 42324 DATA3 DATA1 I'd like to return the matching: 12312 12323 33333 42324 How can I get this in query?

ORA-01650: unable to extend rollback segment R03 by 64 in tablespace RBS03 Would adding more space resolve this?

TABLE_A ------- FieldA - Primary Key FieldB FieldC FieldD FieldE - A Summary Field FieldF - A summary Field In this data, aside from FieldA, there is duplicates. FieldA is unique, but columns FieldB, FieldC and FieldD are identical. How can I determine which FieldA's match? The summaries in...

Is there a way to create a CSV file using PHP and pulling the data from MySQL? Any ideas that could guide me? Thanks! JE

What is the quickest way to pull Schema DDL from an oracle schema (9i)? I have a schema with tons of tables, indexes, etc... and I want to pull that to another database without pulling the data with it... it will be on a diff. tablespaces, etc... Thanks for any ideas! Thanks JE

How can I put 0's in front of a number as a mask? For example... I have the number 13. I want it to be.. 000000013 or if the number is 7 000000007 Thanks for any help!

How can I populate a field with current system date and time? Is there an option to automatically populate this when a record is inserted?

How can I pull two lines with a script based on a grep? For example, my file will have multiple lines like teh following... in random places... I want to pull "TEST" and the number below it.. how can I do that? TEST 343000 Randome info... TEST 454646 More Random info.. TEST 12312312

I have a script that select's data. There is a certain field that at times has "NULL" values. If it's NULL, I want to put "NA" in that field... how can I do this? Thanks! JE

Any ideas what coudl be going on? EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 26: PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared ORA-06550: line 1, column 14: PL/SQL: Statement ignored EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 26...

How can I do an nfs between HP-UX 11.11 boxes? I have some huge files that I'd like to copy over from one box to another... i have a directory that is approx. 7gigs... thanks for any guidance?

How can I drop tablespace on Oracle if the databafile has been deleted? Thanks! JE

I'm getting the following after installing sdk 1.4.2_08.. any ideas? java/lang/NoClassDefFoundError: java/lang/Object