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 - Original Message - From: Senthil Kumar D To: Multiple recipients of list ORACLE-L Sent: Thursday, June 19, 2003 3:24 PM Subject: APPS 11i (Linux) question Hi Group, I'm installing apps 11.5.8 on Linux 8. Rapidwiz , first unzipping some 55 components. After 54th component is hanging and the unzip process is getting "defunct". Anybody faced the same issue during the installation. Any help on this Reg. Thanks, Senthil.
Re: MS SQL hasn't given up!
Hi I saw this list posted on an Oracle Newsgroup a while back :-) Oracle has multiversioning. SQL Server has no equivalent In Oracle reads don't block writes and writes don't block reads In Oracle there are unlimited row level locks In Oracle there is no such thing as lock escallation or page level locking In Oracle there is no need to use temp tables to accumulate intermediate level results In Oracle phyiscal transactions can be as large as logical transactions. No need to fragment them Oracle runs on platforms other than Windows Oracle has many trigger types not available in SQL Server Oracle lines the pockets of Larry Ellison rather than Bill Gates. Which means that someone is having fun with your money rather than just hoarding it. Also look at the link below for a longish (400+ lines) and very detailed technical comparison. http://groups.google.com/groups?q=faulkner+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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to start with Oracle Financial?
Hi > Alternatively, rather than playing the E-Bay lottery you can go to the > Oracle store and buy the same for 39.95 USD. Theoretically you should also > order a trial license but these are free so what's the point. Anyone? Am I > missing something here? I have ordered the Linux version of 11.5.7 and can confirm that no keys are asked for during the installation. The CD pack contains an option to install a sample database called VISION which is a fully populated trial database The VISION database does contain Financials (among many other things). Everything in there seems to work correctly although my tests have not been to extensive as yet. The install can be tricky, You should really use a supported OS and version. Judging by various posts on the Net, the NT version seems to have an especially evil reputation. I have put online a paper on how to install 11.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 official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OFF TOPIC: Jedis, etc - was Top 10....
> Not true. This isn't a list for urban myths - if you're going to go > off-topic, you could at least do it accurately. :-) > http://www.statistics.gov.uk/cci/nugget.asp?id=293 It would seem you have the definitive source. However, I wasn't just repeating something I heard down the pub. I was actually quoting direct from the most recent issue of "The Week" a serious UK weekly news magazine. A google search seems to show that many others have also been hoodwinked http://www.channel4.com/news/2003/02/week_2/13census.html http://www.ananova.com/news/story/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 'Other religion' along with Druidism, Satanism, > Wicca, Pagan, Freethinker, etc, etc. The total for ALL these was only > 179,000. > > Of course, Jedi only got as many 'votes' as it did because of a spoof email > which tried to convince people that it would make it into an 'official' > religion. Which is, of course, complete twaddle! > > > > -- > Peter Moore > Systems DBA, > SchlumbergerSema, > Reading > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: 25 February 2003 08:14 > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, > > > > > > > Perhaps we depend to much on the force to guide and protect > > us at times... > > > :-) > > > > Laugh you may, but in the last UK census (not a poll mind you > > but the actual > > national census) 400,000 people indicated their religion was > > "Jedi". This > > was more than put their religion as Sikh, Jewish 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://www.DataBee.com/dt_home.htm > > > _ > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented are > solely those of the author and do not necessarily represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised that you have received > this email in error and that any use, dissemination, forwarding, printing, > or copying of this email is strictly prohibited. > > If you have received this email in error please notify the > SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. > _ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: MOORE, Peter Rbh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Top 10 DBA Do's and Don'ts anyone - Here is my list,
> Perhaps we depend to much on the force to guide and protect us at times... > :-) Laugh you may, but in the last UK census (not a poll mind you but the actual national census) 400,000 people indicated their religion was "Jedi". This was more than put their religion as Sikh, Jewish 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://www.DataBee.com/dt_home.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 > the warnings and had a copy of Suse 7.0 at home so I've only ever installed > it onto the recommended platform. Armed with your summary I may have a shot > at installing it on 8.1. > > >> The link below contains a summary of my experiences in installing >> Oracle Apps 11i (11.5.7) on Linux (Redhat 8.0 and SUSE 8.1 >> Professional). >> >> I'm posting it because I would really have appreciated being able to read >> something like this prior to starting my installation :-) >> >> http://databee.com/apps11i_install.htm >> >> Regards >> - 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FYI: Installing Oracle Apps 11i on Linux
Hello AllThe link below contains a summary of my experiences in installingOracle Apps 11i (11.5.7) on Linux (Redhat 8.0 and SUSE 8.1Professional).I'm posting it because I would really have appreciated being able to read something like this prior to starting my installation :-)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 technical alert which is being sent as a service to all MetaLink users! The following alerts have been published on MetaLink by the Oracle Security Compliance team: Oracle Security Alert #48 Dated: 11 February 2003 Severity: 1 Buffer Overflow in DIRECTORY parameter of Oracle9 i Database Server (Document ID: 229284.1) Oracle Security Alert #49 Dated: 11 February 2003 Severity: 1 Buffer Overflow in TZ_OFFSET function of Oracle9 i Database Server (Document ID: 229285.1) Oracle Security Alert #50 Dated: 11 February 2003 Severity: 1 Buffer Overflow in TO_TIMESTAMP_TZ function of Oracle9 i Database Server (Document ID: 229286.1) Oracle Security Alert #51 Dated: 11 February 2003 Severity: 1 Buffer Overflow in ORACLE.EXE binary of Oracle9 i Database Server (Document ID: 229287.1) Oracle Security Alert #52 Dated: 11 February 2003 Severity: 2 Two Vulnerabilities in Oracle9 i Application Server (Document ID: 229288.1) MetaLink Security Alert Dated: 11 February 2003 Severity: 1 Security Vulnerability in E-Business Suite Release 11 i (Document ID: 229257.1) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Using Soft Links for Datafiles
> We are in the process of creating a 9.2 RAC database. And we are being > forced to follow a standard whereby, all files are to be in a directory > structure, say /local. No standards have yet been defined, if one were > using raw volumes. And since we will be using raw volumes for the > datafiles, to enforce the standards, we are being asked to create symbolic > links from /local datafiles to the raw volumes. To convince them otherwise, > I have seemed to dug up two issues. [... stuff snipped] One word of warning about using symlinks to point to datafiles is that you have to make sure your datafiles get backed up. Since you are using raw disk this probably isn't an issue and have arranged appropriate backups. However, I have seen it done where a DBA wanted to move a datafile and rather than doing it properly just shutdown the DB and moved the datafile and then put a symlink to the new location in the original spot. The database will start and operate just fine -but- most backup sofware will go trolling down DBA_DATA_FILES and backup up only the symlink (its really a tiny little file on UNIX) rather than the database itself. In other words the backup 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 see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problem with LONG column
Title: Which rollback segment is currently active? Hi Banarasi >One of my development team is working on ORACLE 8 on NT (Because of client requirement they are working on that version). One Table was created with wrong column name. Now they wanted me to correct the column name. But real problem is one column of that table is LONG data type. So I was unable to use Insert into ... Select statement. Any suggestions in this regard highly appreciated. Investigate the SQL COPY command. It will copy LONG columns. I think you'll probably find it in the SQLPlus manual 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
Hi > Do you know any 3rd party software (other than Adobe Acrobat) that convert few hundred pages of PDF to TXT. > Sorry for the OT but please guys, is quite urgent thanks There are loads of them - including some freeware ones (IIRC). Just do a Google search on "pdf2txt" and 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 City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Script to recreate schema
> > I'm sure many of you have scripts to recreate an Oracle schema including > > objects (i am interested in tables, indexes , comments, views, sequences, > > triggers, stored procs/functions etc..) > exp userid=system/manager file=schema.dmp rows=n owner=scott > 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-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Direct and indirect foreign key relationships in SQL or Pl/Sql
> How do I find out the direct and indirect foreign key relationships? > Say, for example there are four tables A, B, C and D of which A is the > parent table and B, C and D are child tables. Say B and C are related to A > directly and D is related to A through C. How do I find out this indirect > relationship apart from the direct relationships? Any help in this regard > is very much appreciated. The DataBee software has a Chain Finder tool in the Set Designer which displays exactly this. DataBee is designed to create referentially correct subsets of Oracle databases and isn't free. However we do offer a 30 day evaluation which might enable you to get done what you want to do. If you would like to have a go at it drop me a note and I'll arrange to get an eval key over to you. Here's a link to the Chain Finder help page - it has a nice picture 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 City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Methods to get DDL
> I do have a set of sqlplus scripts that we wrote for 7.3.4 that generate > DDL for objects in the database. > > So, you can write your own. All the neccessary information is in the > catalog. It is for the more common stuff but for some objects the information is so deeply buried 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 see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: export porblem ???
Hi Is it possible you FTP'd the export file across to the new machine in ASCII mode (the default on win systems)? Always ensure you use BINARY mode - the stray LF's get substituted by CRLF's inside the export file and it really messes up the internals and can sometimes the imp utility 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. > everything completes succesfully and even the log file > says "EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING". > > But while importing it,only 17 tables are imported. > after that the cursor stands still and the import does > not process further.the remaining 16 tables are not imported > at all. > > why is it so ? have any of you come across such situation ? > > will datafiles of size greater than 2G cause such problem ? > > the DB is on oracle 8.1.6/Win2k. > > kindly let me know guys. > > TIA. > Jp. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: oraora oraora > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Something that might be of use
Hi Stephen > The program is functional but not necessarily > elegant. Of course, no guarantees about anything are made. If you make any > improvements, I would be most appreciative if you sent them. If you need this sort of thing you might consider having a look at the freeware DBATool. It is designed to do exactly what your program does - but it has GUI interface and a lot finer control over the manipulation of the DDL. You can independently change or remove every component of a tables storage clause independently and can even use wild cards. For example: all tables get 1M extents except for tables like XYZ% which get 100K extents except for tables XYZ1 and XYZ2 which get 10K extents. You can also put OR REPLACES automatically on packages procs etc, reset sequences to known starting values, and change the target of DB links. Its all driven by rules - so once you set it up 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 > dev, space and file system availability often require us to just get > something working without regard for performance. In these cases, extent > sizing in the exports often prevents us from loading even a row-less import > into the test/dev database. The following C program was written to deal > with those situations. I have used it enough that I think I can go ahead > and toss it out to the world. The program is functional but not necessarily > elegant. Of course, no guarantees about anything are made. If you make any > improvements, I would be most appreciative if you sent them. -- 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Apps 11i on Red Hat 8.0
Anyone care to share any experiences installing Apps 11i release 7 on RH 8.0? I'm about to give it a go in the next couple of days - and would appreciate hearing about your experiences. I note that SUSE 7.1 seems to be the only officially certified distro. H. Oracle Trivia Question: "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://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Monitoring Tool Evaluation methodology
Hi Ferenc > Why don't companies do more DD before naming products ? The Gurkhas were > special forces in the British Army, trained to DESTROY and DEMOLISH ! So, > is this an electronic version of it (eGurkha) ? Not likely to score points > with the Brits for installing this on 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 scripts for your Oracle database + DDL to HTML conversion for instant documentation. 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 Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Move ALL Data from 1 Database into Another
Hi Jeremiah > I don't like any of the suggestions so far, because they take more > time than necessary. DB links do ONE ROUND TRIP for every row > fetched! That is not efficient. Export is a nightmare of potential > failures. I think you can devise the best solution by just copying the > database files. Are you sure about the "one round trip" thing. I may be mistaken but I must admit that has not been my experience. Are you thinking of occasions when you use a remote table (accessible via a DBLink) in a local join? In such cases the optimizer might set up the plan to get the remote rows individually rather than doing unproductive remote full or range scans. One would anticipate that a query like INSERT into (select * from remotetable@link) would pull things over in a stream. OCI certainly streams query results like that - I'm not saying that DBLinks 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 Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Move ALL Data from 1 Database into Another
> What about foreign keys, functions, procedures, synonyms, roles, grants and > triggers (if any)? I've used the db link and it's faster than imp/exp but > it doesn't do anything for other database objects. Also, if you do have > foreign keys then a certain amount of pre-planning is necessary to move > data in the right order. Actually in this case you can have your cake and eat it too. Use the freeware DBATool to generate the database recreation scripts. Run the the scripts to create all of the structure (including foreign keys, procedures, synonyms etc). 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 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Read Only Login with Source Visibility
Hi Bill > I am trying to create a read-only login, RO_USER which can do the following: > 1. See all tables, views, constraints etc. in one *specific* other schema, > 2. See all the source for PL/SQL objects in APP. Is what you really want is a way for users to be able to see the DDL and PL/SQL without actually being able to run or modify it? If so, as a suggestion, why don't you try using the DDL to HTML documentation generator in the freeware DBATool. You could easily cut a browsable tree with all (or part) of a schemas DDL. It also does nice things like cross reference related entities - for example for a table you can click on links to the associated indexes, foreign keys, grants, synonyms etc. Password protection and security can easily be implemented by moving the HTML tree onto a password protected drive. An example tree can be found at the link below http://www.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-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to get rid of a column default value ?
Hi Louis > Anyone knows how to get rid of a column default value ? I rtfm and search > metalink with no luck. Just set the default back to NULL. To apply the default: ALTER TABLE "BONUS" MODIFY ("COMM" DEFAULT 10 ); To remove the default: ALTER TABLE "BONUS" 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 -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Way of extracting record
If the schema has any complexity then manually identifying and extracting the required dependent records can be quite troublesome. There is a white paper on the DataBee web site entitled "Test Database Generation and Management" that discusses the issues in some detail. http://www.databee.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 customer have a production and > development system , if there is a problem log being raise , > then we need > to > port the data from development to production but not the > whole database > sometime is only certain record. > > Is there any method to use instead of generate insert statement for > necessary table(PROD) and run the statement (DEV) ? > > I do think of using XML but I don't know how to do it -- 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 Oracle test and development environments at the push of a button. http://www.DataBee.com -- 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 schema documentation? Check out the DDL to HTML generator in the free DataBee DBATool. 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 Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Constraints problem
Hi > I had to copy a set of tables with data from one schema into another. > I did this by using "create table as select * from master_schema.table_name; > But the constraints ( primary key, foreign key etc) are not created in the test schema. > Is there any way to implement all the constraints (in the master_schema) into the test schema? Grab the freeware DBATool. It can generate schema DDL scripts and can easily generate the recreation scripts for all dependent objects on a table (indexes, fk constraints, synonyms etc). The DBATool is specifically designed to create 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 ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB copying : Attack of the Clones!
Hi Kirti Do you absolutely need full size copies? If small referentially correct subsets were suitable you could use our DataBee software to "re-create and re-load" the test databases as necessary. In other words, you would not need to back up and restore full size databases. You simply press the button and regenerate the subsets when required. Depending on the size of the subset, the refresh would not take more than an hour or two. The load process is quite straight forward - many of our customers just create the initial subset databases and then off load the "truncate and reload" work to the developers and testers themselves. The DBA's are removed from the loop and because the databases are small the create process is very quick - the developers and testers can refresh their databases whenever they want. Actually, DataBee would clone the full size databases just fine - its just not really designed for that purpose in mind. DataBee: http://www.DataBee.com In any event, you should have a look at our freeware DBATool. It contains (among other things) a rule based schema adjuster that should take care of your requirements to modify the DDL 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 entirety for ongoing code testing, > recreating production problems etc. > > BTW, if we decided on any 3rd party tools, then Dgmt wants it installed > within the next 4-5 weeks. Any Vendor types lurking on the list? This is > your chance :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Replicating a user across DBs
Hi Jesse > In 8.1.7, is there a way to easily replicate a user from one DB (e.g. > "development") to another (e.g. "production")? I can export all the objects > in the schema, but export/import won't recreate the schema in the import DB. > > I've been using OEM to create a script (reverse engineered from "Create > like..."), but the resulting script requires editing and the assignment of a > resource plan doesn't always play nice, either. > > There has got to be a better way... The freeware DBATool will do this. It reads 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: 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Free Open source PL/SQL Editors / DB management tools
Hi > are U aware of any free open source PL/SQL Editors or freeware/open source > tools for database management ? > If so , would u please post an URL of a such . Depends on what you want for Database management - if you need to document schemas or re-create them elsewhere the Free DBATool might be of interest to you. http://www.databee.com/dt_home.htm The DBATool is designed to read an Oracle export file and create executable DDL from it which can rebuild the database - its simple to use and quite useful for DBA's and developers. The DBATool can also strip off (or substitute) storage clauses and other DDL components and pull out as DDL all dependencies (indexes, FK's, grants etc) for a selected group of tables. One of the more popular features is the DBATools ability to dump the schema structure out to a linked HTML tree - instant documentation. An example can 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: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Subset Tool?
Hi Jared > Do you know if anyone has successfully used this tool > on an SAP database? That would be *truly* impressive. No, there has not been a SAP implementation. There is no reason why DataBee could not do it though. We would be willing to work closely with someone (and provide 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 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Subset Tool?
Hi Jared > I've seen some pretty ugly schemas in Oracle, from third > party apps in particular. > > It would be most interesting if an automated tool could > subset these. They do get ugly don't they - however, I would be very suprised if DataBee was not able to cut a subset. DataBee is quite simple in concept - at its most fundamental level it processes a list of rules which tell it which tables need which supporting rows from other tables. The schema complexity is largely an irrelevant issue - DataBee takes things one rule at a time and says "I have this row in this table therefore I need these rows from this table based on this join condition). It is very fast and implicitly eliminates duplicates. It is also interesting to note that table size is also not super important. Sure the extract is slower on large databases, but the extract time scales upwards 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 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 / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Subset Tool?
Hi Jared Disclaimer: I work for Net 2000 Ltd. the authors of DataBee - a database subsetting tool. > Disk is cheaper. :) It only seems so because manually creating subsets is such a nightmare - but if you have large databases it just isn't practical to give every developer, tester and trainer a full size copy of production. So what do you do? Well if your like most DBA's you create far fewer copies of the big database than is really needed and everybody has to share it. Then the trouble starts: the developers the collide with one another, the testers trash each others data and everybody squabbles because they have to wait for a time slot. Truth be known - developers, testers and trainers don't like to work on full size copys (it slows them down) and they don't like to share. As you say, manual subsets are not cost effective because of the DBA effort involved 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 -- Author: Dale Edgar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Subset Tool?
Hi Larry Disclaimer: I work for Net 2000 Ltd. the authors of DataBee. >...but does anyone have >recommendations on a tool that will create a subset of production data that >is referentially intact? I am aware of DataBee... I don't mind telling you who the competition is - we are confident that we are better value both in price and functionality:-) Two other subsetting tools on the market are DataManager from Quest http://quest.com/schema_manager/ and CheckMate from BitByBit http://www.bitbybit.co.uk >, but it might be more cost effective to buy > something if the price is right. The main feature I would be interested in > is a tool that maintained the distribution characteristics of the data. DataBee is designed specifically to cope with this requirement. You can set up the rules (called an Extraction Set) based on multiple drivers. You could, for example, sample 10% of a table (even on ora7.x) and then put on other rules which pick up specific date ranges. You can also use multiple tables: ie get 5% of all invoices from the INVOICE table and 25 specific customers from the CUSTOMER table. DataBee would cheerfully get all of the customers to support the invoices and all of the invoices to support the customers. Basically the rows are adjusted until every table has the data required required to support all of the rest and the subset is in balance. > I know it can be built by hand They can but it is (as I'm sure you know) a lot of hassle - and it can be a nightmare to get the FK constraints to re-enable if you have a lot of them. An automated tool really is cost-effective. One of our customers used to take a week and 45 skilled DBA hours to cut a subset database - even then only about 200 of the 500 constraints would enable. DataBee 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 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: USER DUMP HOW?
Hi Diego > Or you can write your own scripts, I have found this one between my scripts, > I have never tested, I prefer to use Import/Export for that kind of job. The easy way to do this is to get the Freeware DBATool. It will read an export file (created ROWS=N) and present you with the DDL contents in a nicely formatted and intuitive manner. It does lots of other things as well - you can generate recreate scripts for all or part of a schema. (for example: a script that recreates a role and every grant it has). The DBATool can strip of storage clause information from every DDL bit code with a single button press or dump the entire schema out to an HTML tree and just browse through the DDL as it suits you. The DBATool is currently in beta. The second beta release (which cleaned up a lot of 9i issues) was just released today. Download the DBATool from http://www.databee.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 access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 DataBase SubsetsCreate small training and development databases the easy way. http://www.databee.com
Re: Datatype
Hi Ken > Is there an Oracle datatype of DATETIME? I can only find DATE in my > documentation. Oracle DATE datatypes have the time in them as well. Probably it is not being displayed by default on a SELECT because the NLS_DATE_FORMAT in your init.ora is set to the default. To get times in and out of DATE datatypes investigate the TO_CHAR and TO_DATE SQL functions. It should be in Chapter 4 or so of the Oracle 8.1.6 SQL reference manual. (see http://www.oradoc.com/ora816/server.816/a76989/toc.htm) other Oracle versions may vary slightly. Here's an example: select to_char(sysdate,'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: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle error after recovery
Hi Ron > I did a complete recovery of an Oracle instance. Everything looked great > but when I bounced the instance > and tried to bring it back up I got the following Oracle error. I have > checked everything. There are no other > instances running. Do you still have a sgadef.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 Oracle databases. http://www.databee.com -- 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 / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Training Database
Hi John > 1. Is it possible to setup a database that is a subset of a production > database for training purposes (Oracle 10.7 and Oracle 11i)? > If so, how is this done? If the schema is of any complexity this can be quite difficult. If you do it manually you should prepare yourself for a trip through PL/SQL hell. Not only do you have to get the data from every table required to support the rows in the others - but you also have to sift out duplicates. I've needed to do this a lot in the past and have not been terribly happy with the tools on the market. So I wrote my own. The software is called DataBee and it is available now. I haven't really started to promote it yet - I'm waiting until the end of June when I'll have quit my day job. There are two other software products that can also cut subsets (both are more expensive and harder to use than DataBee 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 free @yahoo.com address at http://mail.yahoo.com -- 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 / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 been tasked with writing the Oracle Standards Document > > at work. You know the sort of thing I mean - naming conventions for > > tables, columns, datafiles, tablespaces &etc, mount points, init.ora > > standards et al. > > > > Would anybody be willing to send me the standards document you work > > from to use as a template? It would be much appreciated. The O/S is > > AIX - but any doc would be appreciated. > > > > Thanks in advance > > Dale Edgar > > There are some standards available in the 'Standards' section of the > Oriole Web site - not a lot of things, we optimistically relied on > external contributions to thicken the section a bit, but ... > If you happen to find more interesting things to publish, don't forget > us ... > -- > Regards, > > Stephane Faroult > Oriole Corporation > Voice: +44 (0) 7050-696-269 > Fax:+44 (0) 7050-696-449 > Performance Tools & Free Scripts > -- > http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs > -- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult ([EMAIL PROTECTED]) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- 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 / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 workfrom to use as a template? It would be much appreciated. The O/S is AIX - but any doc would be appreciated. Thanks in advanceDale Edgar