Search results for query: *

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

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

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

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

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

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

Hello, Though at this point there are various ways to get DDL for schema objects, is there a way to get DDL (for tables,indexes,procedures,triggers etc.) using the Data Pump? Yep, in the the legacy imp\exp you can use IndexFile= and there also is dbms_metadata.get_ddl(). I was wondering if...

Hello, How can I completely deinstall Spatial (MDSYS) from an Oracle 10g database? I have searched Oracle, docs, Google and various other sources without even getting close to understanding the steps to do this? Thanks, TD

Hello, For a given tablespace datafiles how can I determine each file's bytes used and bytes free? I have been tinkering with dba_data_files and dba_tablespaces but I am confused as to which fields are doing what. Thanks, TD

Hello All, This command shows the full path to all the data files in the database: select file_name from dba_data_files; How can I output just all the unique full paths and not the file names (system.dbf etc.)? I want to do this so I know what physical directories need to be created upon a...

Hello, In an Oracle 10g database how can you set the value of a SQLPlus variable to the contents of a small text file? Thanks, TD

Hello, Are there any views other than these to display what privileges a user has? DBA_AQ_AGENT_PRIVS VIEW DBA_COL_PRIVS VIEW DBA_PRIV_AUDIT_OPTS VIEW DBA_REPGROUP_PRIVILEGES VIEW DBA_ROLE_PRIVS VIEW DBA_RSRC_CONSUMER_GROUP_PRIVS...

Hello, Is it possible to connect to an Oracle 10g database over the Internet via SQLPlus or Java app from a client system (assuming my local firewall permits the listener port I use)? If this is possible how can it be made secure? Thanks for your comments, TD

Hello, In an Oracle 10g database I have two tables: documents and document_pages. The document_pages is a child table to the documents table. The document_pages table has a varchar2 type field where the values are either: 'HTML' or 'TEXT'. What SQL can I use to get a count of how many...

Hello, In a batch file I am trying to escape a greater than character. Usually I use a ^ character but it does not seem to like this. I also played with escaping the equal sign too. Here is my troubled snippet: set MYVAR=cascade=^>true What can you recommend? Thanks, TD