Search results for query: *

Thanks guys. I was able to retrieve the data required from an old export. But ya know, the more I worked with it and thought about it, the more I was intrigued about trying to achieve this. You could learn a lot about Oracle internals I think if this could be achieved. OCS can't save all the...

Hello, I have an old schema where I have the datafile but no RMAN backup or export. What would be the process to re-online the corresponding tablespace and re-create the schema in a way that Oracle is happy with. Because this tablespace is old and beyond the archive log and RMAN retention...

I am plowing through the steps to understand how the JVM works in Oracle. For others looking for this: create JAVA SOURCE NAMED "Hello" AS public class Hello { public static String hello() { return "Hello World "; } }; / create or replace function Hello RETURN VARCHAR2 as LANGUAGE...

Hello, I can see via the dba_registry that the JAVAVM (JServer JAVA Virtual Machine) is installed and VALID. Can someone recommend a simple call I can run at the command line that tests the Java JVM inside the database (I am not a Java guy)? From SQLPlus a SELECT sysdate FROM dual; does the...

Thanks Santa.

Hello, Can anyone pass on any lessons learned concerning migrating a 32bit Oracle 10g database from Windows 200n 32bit to Windows 200n 64bit? One immediate topic comes to mind (Export\Import). Assuming the databases are created the same, are there any special considerations importing data...

Hello, On files less than 50gb PKZip (version 8 & 9) and 7zip work fine for me. Over 50gb if fails saying not enough system resources. After checking I have confirmed that I have ample disk space and it is defragmented. MS compress blows up somewhere over 40gb per file too for me. Can you...

Hitting this at a lower level... If you have more than 10gb of data Big File Tablespaces (BFTS) can be effective. Also, make sure you are using Locally Managed Tablespaces (LMTS). On this topic, check for ancient and outdated Oracle practices on the creation of DB, TS and Tables. If Windows...

PHV, Niceley done. Thanks for posting. TD

Hello, How can I extend the below SQL so as it will return all string matches for 20080513 and greater. Greater in this case would mean values like: myfile_20080514.bus, myfile_20080515.bus etc. SELECT fname FROM V$BACKUP_FILES WHERE fname LIKE '%20080513%.BUS'; Thanks, TD

Hello, I have found that if I add a new archive log dest (ALTER SYSTEM SET log_archive_dest_n=) if I bounce the database I can see it is being used. At what point does a newly added log_archive_dest_n become active? Can it be made active without bouncing the database? Thanks, TD

Thanks Santa - it worked! :-)

>> Do you want some "useful ammunition" to justify the purchase, along the lines of all the things managers forget to take into account when costing such things? Yes! :-)

thargtheslayer, Thanks for your feedback. I think you are right on target. I agree with you concerning the E.E.. Some employers do not know how to count the value of I.T. investments. They ONLY see the hit. They are quick to favor any solution that is "soft" dollars based, i.e. countless...

Hello, Can anyone offer any ways to encrypt both RMAN backupset files and Data Pump dump files without purchasing the Enterprise Edition? Our RMAN backups go to disk. The databases that we need this on consist of about 3 terabytes of RMAN\DataPump data. Thanks, TD

Hello, I was looking to put together a tech support page where the user would click on a link and via JavaScript, open a popup window. Yep, this is common and easy to do. Is it possible to open a page and base the content on just a section of an HTML page? A example page content would...

Hello, I have a database that only has two control files and I want to add a third. I want to add X:\oradata\DB1\recovery3\control03.ctl. The only docs I seem to be able to find with examples are all 9i and older. Will this work in 10g? SQLPLUS> ALTER SYSTEM SET...

Vragabond, Thanks for posting. :-)

Hello, Does Window 200x keep an internally incrementing timer available to a DOS console? In some OS's it is implemented as minutes since 1982 or something simliar. Thanks, TD

Hello, Using HTML\CSS how can I change the bullet type in the <li> tag to &middot; or something simliar? The HTML default is "disc". I'd like to change it without using an image. Thanks, TD