Re: Way of extracting record

/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 customer have

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

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 -- Author: INET: [EMAIL PROTECTED] Fat City Network

Re: Read Only Login with Source Visibility

/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-538-5051 http

Re: Move ALL Data from 1 Database into Another

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 see the official ORACLE-L FAQ: http://www.orafaq.com

Re: Move ALL Data from 1 Database into Another

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 Diego, California

Re: DB copying : Attack of the Clones!

://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 entirety for ongoing code testing, recreating

Re: Constraints problem

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 ORACLE-L FAQ: http

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 -- Need instant

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 referentially correct

Re: Replicating a user across DBs

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: http://www.DataBee.com Regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see

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 official ORACLE-L

Re: Monitoring Tool Evaluation methodology

? 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 scripts for your Oracle

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 see the official ORACLE-L FAQ: http

Re: Something that might be of use

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 dev, space and file

Re: export porblem ???

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. everything completes

Re: Methods to get DDL

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 see the official ORACLE-L

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

://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 City Network Services-- 858-538-5051

Re: Script to recreate schema

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-L FAQ: http://www.orafaq.net -- Author: INET

Re: Urgent PDF to TXT Convert

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 City Network Services

Re: Problem with LONG column

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: Using Soft Links for Datafiles

. 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 see the official ORACLE-L FAQ: http

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 technical

FYI: Installing Oracle Apps 11i on Linux

://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: 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 future. I read

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

. 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://www.DataBee.com/dt_home.htm -- Please

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

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 'Other religion' along with Druidism, Satanism, Wicca, Pagan, Freethinker

Re: How to start with Oracle Financial?

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 official ORACLE-L FAQ

Re: MS SQL hasn't given up!

+sqlserverhl=enlr=lang_en ie=UTF-8oe=UTF-8newwindow=1selm=FssV9.25204%24jM5.66998%40newsfeeds.bigp ond.comrnum=4 - Dale - Instant schema documentation for free? Check out the DDL to HTML facility in the freeware DBATool. http://www.DataBee.com -- Please see the official ORACLE-L FAQ: http

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

://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: (858) 538-5051 San Diego

Re: USER DUMP HOW?

/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 access

Re: Data Subset Tool?

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 INET: [EMAIL PROTECTED] Fat City Network

Re: Data Subset Tool?

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 -- Author: Dale Edgar INET: [EMAIL

Re: Data Subset Tool?

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 the official ORACLE-L FAQ: http

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 you

Re: Oracle error after recovery

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 Oracle

Re: Datatype

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: [EMAIL PROTECTED

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 - Oracle

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 - Dale