Search results for query: *

hi guys, brain dead here because i cannot find the oracle dictionary table/view that will give me the name of the tablespace used by each partition in a partitioned table ... help please ... regards, david - no such thing as problems - only solutions.

tried this on oracle reports forum a week ago but no response, so cross-posting to try again please ... Reports 10.1.2.0.2 on xp trying to format a new report with basic sql query as csv output but output file full of unrequired data ... eg first few lines of output file ... %-12345X@PJL...

Reports 10.1.2.0.2 on xp trying to format a new report with basic sql query as csv output but output file full of unrequired data ... eg first few lines of output file ... %-12345X@PJL JOB @PJL COMMENT MS PCLXL NT Driver @PJL SET STRINGCODESET=UTF8 @PJL JOB NAME="xxx03a" i have read the...

hi guys, exporting data into a csv file using 10GR2 utl_file need to check if data from several fields have comma(s) in them and, if so (iaw client's spec), wrap column data in double quotes (normal standard for csv files) eg ... qwerty = qwerty qwe,rty = "qwe,rty" qw,er,ty = "qw,er,ty"...

reverse-engineering 9i application for documentation ... am i missing something here as i cant find anything obvious in the dictionary, documentation, tek-tips, google etc ? i want to identify which package procs/funcs are declared in the package spec (public) or just in the pkg body (private)...

i got fed up with reinstalling xp from disk and adding all sp and patches etc so, i copied boot dive (c) and restored to a bigger 300gb drive which has a 100 gb active partition for os and 200gb partition for data new drive seems to boot ok ... mother board splash screen win xp pro splash...

VSS 2005 standard view ? right hand panel = name, user, datetime, check out folder is there a way to add a column to dispaly the version number please ? VSS admin guy is scratching his head ... regards, david - no such thing as problems - only solutions.

oracle job scheduling mainly covers dbms_scheduler excellent book very comprehensive informative well priced ($US 16.95) isbn = 0-9744486-6-4 rampant press = http://www.rampant-books.com/ bit of a hiccup with the initial shipping to oz but it eventually arrived considering the dearth of...

working in a 4-node rac environment ... currently converting all dbms_job jobs to dbms_scheduler jobs and investigating all options available ... could anyone throw any light on the following two columns please ? dba_scheduler_jobs.source and dba_scheduler_jobs.destination desc column...

greetings, select * from all_scheduler_jobs is consistently giving me an oci_invalid_handle error in toad 8.0 (reverted from 8.5 because it was giving me errors with ext tables ... havent tried 8.6 yet) if i open another toad session it "sometimes" will run the query ok only happens for...

no luck with this on (very quiet) quest software forum ... Anybody know if i can view dbms_scheduler tasks in TOAD 8.5.3.2 please ? (similar to jobs in schema browser) i cannot find anything in app or docs etc - maybe that functionality has not been included yet ? regards, david - no such...

Can anyone tell me how to identify if a pk index has been : a. explicitly created by a user or b. has been implicitly created by oracle when a user creates a pk constraint info from data dictionary index and constraint tables seems to be identical i already know one destructive way ...

this is something that i have not encountered yet ... can i identify if a particular table partition is locked and, if not, can i lock it ? regards, david - no such thing as problems - only solutions.

help, finger trouble ... i used to have a multi-tab selection near the bottom of the screen to quickly select between sql-editor(s) and schema-browser etc i lost it yesterday by clicking something without reading and i cannot find the option to get it back. i have tried various things eg...

alright i give up ! i created a pass-through-query to an oracle database and opted not to save password now, everytime i run the query, it pops up with testing uid disabled (ie i can not change it) and prompting for a password i need to allow several users to run the query with their own uid...

a colleague's tests appear to prove that the results of an oracle minus operation are always distinct but i cannot find anything in the official oracle sql references (surprise surprise !!!) i have found other references which indicate that minus is a synonym for iso-sql except distinct (which...

hi, does anyone know if the OTN toolbar, released in 2002, is still available please ? URL ? i had forgotten all about it (moving between client sites) until i come across a printout that i kept searched OTN to no avail ... regards, david - no such thing as problems - only solutions.

HELP ! anyone know how to easily identify version of ms word that a doc was created in or last saved in ? preferably before it is opened ... doc saved in word 2k/2003 freezes word 97 when opened - task manager shows nearly 100% word cpu time resorted to getting local user with newer version...

could anyone help me with sample syntax, or point me to some examples, to recreate table from template using a different tablespace ? eg create table new_table_name as (select * from template_table) tablespace target_tablespace is the tablespace syntax correct/recommended ? regards, david -...

working on warehouse project need to rename temporary table after data load eg could be to partition name pl/sql will not accept dbms.sql or execute immediate statements i am obviously missing something ? help ! regards, david - no such thing as problems - only solutions.