Re: APPS 11i (Linux) question

Hi Senthil   I don't have any information on your specific problem - but I did write up a summary of my experiences installing 11.5.7 on Redhat 8 and SUSE 8.1  You might find elements of this to be useful during your install.   http://databee.com/apps11i_install.htm   Kind regards -

Re: MS SQL hasn't given up!

ner+oracle+sqlserver&hl=en&lr=lang_en &ie=UTF-8&oe=UTF-8&newwindow=1&selm=FssV9.25204%24jM5.66998%40newsfeeds.bigp ond.com&rnum=4 - Dale - Instant schema documentation for free? Check out the DDL to HTML facility in the freeware DBATool. http://www.DataBee.com -- Plea

Re: How to start with Oracle Financial?

1.5.7 on on later versions of Linux - not really for the inexperienced in UNIX or Oracle. http://databee.com/apps11i_install.htm Regards Dale Edgar --- Need test and development databases? Generate them at the push of a button with the DataBee software. http://www.DataBee.com -- Please see the offi

Re: OFF TOPIC: Jedis, etc - was Top 10....

tory/sm_750289.html Sigh, quality journalism that. I guess I should have dug a bit further before repeating it. Oh bother, I'm still off-topic, soy... -Dale > Sikh - 336,000 people. > Jewish - 267,000 people. > Buddhist - 152,000 people. > > Jedi was classified under 'Ot

Re: Top 10 DBA Do's and Don'ts anyone - Here is my list,

wish or Buddhist. Of course its just a re-hash of Vitalisim, but (Oh dear, now I've annoyed nearly half a million people and all of 'em on the same tiny island as me :-) -Dale -- Generate HTML schema documentation with the free DDL to HTML converter. DBATool: http://w

Re: Installing Oracle Apps 11i on Linux

No problem. If you can figure out a way to install it without using that ugly little adcrdb.sh hack that I had to do I would really appreciate you telling me. Except for that bit the install isn't too bad. Cheers - Dale > thanks for sharing, this is going to be pretty useful in the f

FYI: Installing Oracle Apps 11i on Linux

)http://databee.com/apps11i_install.htmRegards- Dale-Need databases for development and test? You need DataBee - the low-hassle way to create, maintain and refresh test and development databases.  http://www.DataBee.com

Re: Plain Old Database

Message > as we all know Oracle is unbreakable, so security isn't an issue. All of these security alerts (see below) that just hit my mailbox must be just mere formalities :-) - Dale http://www.DataBee.com EMAIL from Oracle below This e-mail is a critical t

Re: Using Soft Links for Datafiles

up software doesn't follow the link. At restore time you find you've simply restored the link and the target file has never been backed up. Regards Dale --- Need databases for development and test? Create and refresh them automatically with DataBee http://www.DataBee.com -- Please

Re: Problem with LONG column

l rather than the SQL Reference.   Regards Dale - Need to generate scripts to re-create the DDL in your database? Check out the freeware DBATool http://www.DataBee.com  

Re: Urgent PDF to TXT Convert

nd you'll find a selection from which to choose. Kind regards Dale Edgar DataBee: Quite simply the easiest way to create test and development databases. http://www.DataBee.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat

Re: Script to recreate schema

vi schema.dmp Instead of "vi schema.dmp" use the freeware DBATool to extract a set of rebuild scripts from the export file. It is much easier and there are a lot of other options available too. DBATool: http://www.DataBee.com/dt_home.htm Regards Dale -- Please see the official ORACLE-

Re: Direct and indirect foreign key relationships in SQL or Pl/Sql

of the relationship display. http://www.databee.com/sdchainfinder.htm Regards Dale - Quickly and easily create test and development databases with DataBee. http://www.DataBee.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat Ci

Re: Methods to get DDL

ried it is next to impossible to figure out how to regenerate. For example, try figuring out how to rebuild the DDL for a Hash Cluster from the catalog. Kind regards Dale --- DBATool: A freeware DDL re-creation tool for Oracle databases. http://www.DataBee.com/dt_home.htm -- Please s

Re: export porblem ???

lity to skip to the end without reporting an error. Regards Dale - DataBee: Software that creates small referentially correct Oracle test and development environments at the push of a button. http://www.DataBee.com > i am exporting a DB of size 10G. > it totally has 33 tables. &

Re: Something that might be of use

p you can save and reload the rules anytime you need them. DBATool: http://www.DataBee.com/dt_home.htm Regards Dale [EMAIL PROTECTED] > We often need to refresh test and development databases with exports that > have extent sizing a lot bigger that what we want. In test and ESPECIALLY &

Apps 11i on Red Hat 8.0

: "If you order the Oracle Apps 11i Release 7 suite from Oracle how many CD's do you get?" Answer: 54 (yes thats right, fifty four CD's) - the mind boggles. No wonder they don't let you download the thing :-) Regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please

Re: Monitoring Tool Evaluation methodology

their systems eh ? Not at all - quite the reverse in fact. The Gurkha regiment still exists and is highly respected in the UK. The Gurkha regiment is renowned for its toughness, loyalty and tenacity. Regards Dale --- The Freeware DBATool: The easy way to generate the DDL re-creation script

Re: Move ALL Data from 1 Database into Another

BLinks are based on OCI - just that there is precedent for this in at least one Oracle networking layer. Kind regards Dale -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: Move ALL Data from 1 Database into Another

The DBATool can also generate scripts to disable (and re-enable) all of the foreign keys. Disable the FK's, pull the table data across via one or more DBLinks and run the FK re-enable script when done. DBATool: http://www.DataBee.com/dt_home.htm Kind Regards Dale Edgar -- Please

Re: Read Only Login with Source Visibility

ww.databee.com/dt_htmltree/db=TESTDB1+sc=DT_TEST.htm The DBATool is freeware http://www.DataBee.com Regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: How to get rid of a column default value ?

US" MODIFY ("COMM" DEFAULT NULL ); Regards Dale -- Check out the freeware DBATool: generate DDL recreation scripts and instant schema documentation via DDL to HTML conversion. http://www.DataBee.com/dt_home.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: Way of extracting record

atabee.com/TestDBGenWhitePaper.pdf We also provide an automated tool designed for the purpose of creating referentially correct subsets of data. It may be useful in your case. Kind regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] http://www.DataBee.com > I need your advise , currently our cu

Re: How to Call C Routine from PL/SQL

Hi Suman > I want to call C Program routine from PL/SQL. What all things I need > to do. ExtProc's are what you need. Check out the very good tutorial at: http://home.clara.net/dwotton/dba/oracle_extn_rtn.htm Regards Dale - DataBee: Software that creates small referentia

Re: Creating Scott/Tiger

Hi Jonathan > I need to create the Scott/Tiger schema in Oracle9i. Does anyone > recall off the top of their head just where the script to do this is > located? The creation script can usually be found in ${ORACLE_HOME}/sqlplus/demo/demobld.sql Regards Dale -- Nee

Re: Constraints problem

test schemas and allows you to manipulate the schema DDL in useful ways (fold many tablespaces into a smaller number, strip off or modify extent and storage clauses etc). DBATool: http://www.DataBee.com Regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official O

Re: DB copying : Attack of the Clones!

in the test schemas http://www.DataBee.com Thanks Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] > I was 'volunteered' to participate in a task force charged with finding > quick solutions (in less than 2 weeks) to support following Dgmt decision: > Clone 14 production databases in their ent

Re: Yesterday's date - unix question

Hi Vladimir date --date '1 day ago' Works on my O/S (RedHat Linux) - your O/S may not support this. Regards Dale - DataBee: Create referentially correct small versions of large Oracle databases for development and test. http://www.DataBee.com -- Please see the officia

Re: Replicating a user across DBs

eads an export file created ROWS=N and will generate the schema DDL from it (including grants TO and FROM, public synonyms dblinks, profiles, etc etc). The DBATool can also adjust or remove the tablespace and storage clauses on the output scripts and has nifty DDL to HTML converter. DBATool: h

Re: Free Open source PL/SQL Editors / DB management tools

an be seen at: http://www.databee.com/dt_htmltree/db=TESTDB1+sc=DT_TEST.htm Regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dale Edgar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

Re: Data Subset Tool?

a free copy of DataBee) who was willing to develop such a subset cut and would place the resulting extraction rules in the public domain for anyone to use. Thanks Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dale Edgar

Re: Data Subset Tool?

pwards with the size in a very well behaved manner. Give it a try if you want. There is a fully functional evaluation version (with sample schema) available for download on the DataBee website. http://www.DataBee.com Thanks Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see t

Re: Data Subset Tool?

lved in making them. If you have an automated tool that just snips out subsets like a cookie cutter then you can have as many as you care to. Cheers Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] DataBee: http://www.databee.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Au

Re: Data Subset Tool?

aBee cuts the subset in 4 hours (its a push button operation once the Extraction Set is setup) and all 500 constraints enable. DataBee: http://www.databee.com Cheers Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dale Edgar IN

Re: USER DUMP HOW?

ee.com/dt_home.htm Cheers Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dale Edgar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: Data Cleansing.

Hi Yuval   Can you tell us a bit about what you would like the product to do (a wish list)   > 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.   Thanks Dale --DataBee - Ora

Re: Datatype

date,'DY DD MONTH HH24:MI:SS') from dual; Regards Dale -- DataBee - Oracle DataBase Subsets Create small training and development databases the easy way. http://www.databee.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dale Edgar INET: [

Re: Oracle error after recovery

ef.dbf hanging around? Try stopping the instance and moving/renaming this file. Oracle Note 18070.1 on Metalink may also have a bit of useful information for you on this problem. Regards Dale -- DataBee - Oracle DataBase Subsets The simple and easy way to create small versions of large O

Re: Training Database

ataBee IMHO) DataManager from Quest http://www.quest.com Checkmate from BitByBit http://www.bitbybit.com DataBee can be found at http://databee.com/ Cheers Dale Edgar Net 2000 Ltd [EMAIL PROTECTED] _ Do You Yahoo!? Get your fr

Re: Oracle Standards Document Sought

Thank you very much for this. Cheers Dale Edgar - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, June 03, 2001 7:25 PM > > Dale Edgar wrote: > > > > Hi All > > > > I've recently bee

Oracle Standards Document Sought

Hi All   I've recently been tasked with writing the Oracle Standards Documentat work. You know the sort of thing I mean - naming conventions fortables, columns, datafiles, tablespaces &etc, mount points, init.orastandards et al.   Would anybody be willing to send me the standards document y