Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. thomgreen

    mview in a Production transactional db

    Unfortunately my explanation was either unclear or misinterpreted. There are no tables being deleted just records. Due to table sizes and join complexity the stardard view was resulting in an unexceptable response time. Thank you very much for the responses... I have worked the issue out with...
  2. thomgreen

    mview in a Production transactional db

    Actually only the records to be reload, will be deleted. table_a ======= project_id emp_id The problem is that an emp_id will be passed to a procedure that will need to insert a value into table a. The proc will first get all project_id's that exist in table under the indicated emp_id. It will...
  3. thomgreen

    mview in a Production transactional db

    I have a developer that that would like to put a materialized view in a production db. The UI is built on a proprietary Java platform so the there is not very much code running from the DB. Performance is not the issue. It is more of a data integrity issue with using a particular table, that is...
  4. thomgreen

    SUN 5320 NAS

    Anyone have experience with SUN NAS devices. I have 2 5320 NAS Heads. The OS is 4321 M2 (Build 2). Network security for my corporation is hammering me about meeting there security standards on this machine by shutting down specific listening ports. The OS has some Solaris commands but is...
  5. thomgreen

    dblink error ORA-00942 & ORA-02063

    I have 3 databases, I will call them: db1,db2,db3 o I created dblinks using the same ddl on db2 and db3 that allow me to access db1. o On db2 and db3 I am using a user with the same name and same privileges and roles - I will call the user bdops o On am trying to access a table (named...
  6. thomgreen

    Upload client file to server via browser

    I do not work a ton with Perl but enough to accomplish small tasks. I have hit a wall with my current task. I want to upload a file from the users local drive to the server but... I also have drop-down & text boxes with data that needs to be parsed out in the perl script. I can upload the file...
  7. thomgreen

    ORA-04068 & ORA-04065 using dbms_output

    I am having a problem with my upgraded 10g db. I used the pre-install script before upgrading my database and made the appropriate changes. Unfortunately it did not give me the correct min value for java_pool, therefore the upgrade, using dbua failed. I was then forced to run the upgrade script...
  8. thomgreen

    Is java1.4.2 certified with 9ias v2

    The certify tool on metalink will not show this information for 9ias v2. The Column 'other' should say yes and have a link but it just has an 'NA'. If anyone knows it would be a big help. Thanks.
  9. thomgreen

    autosizing column height of merged cell - for a range

    Thanks for the Response! Is this code correct. I am having issues with it. It compiles fine but it does not show up on the list when I try and assign the macro. If I take out the 'Target As Range' I am able to recognize the macro but of course it does not run without error. Should it be...
  10. thomgreen

    autosizing column height of merged cell - for a range

    I have workable code for outsizing the height of a merged cell. Unfortunately I need it to work for a range of cells. I did used the working code and put it inside a loop through the range of cells but receive an error. The working (individual cell) code is below and the error to the loop...
  11. thomgreen

    ufsdumping '/' to new disk - new boot disk

    Thanks for the help. it is working as per your instructions. Actually the disk had issues, your confirming the process convinced me to look at the hardware. Your help is much appreciated
  12. thomgreen

    ufsdumping '/' to new disk - new boot disk

    The following error: The file just loaded does not appear to be executable Boot device:disk File and args Boot load failed The file just loaded does not appear to be executable Is there not another step to prep a boot drive. Something about updating the Master Boot Record (MBR)? Does this...
  13. thomgreen

    ufsdumping '/' to new disk - new boot disk

    I work mostly on the db side but have been tasked with restructuring the setup of hardrives in our SUN E450. I need to move '/' root to a new disk/slice. I booted cdrom mount / and another slice, then used a ufsdump/ufsrestore command. I then used the installboot command. I tried to boot up...
  14. thomgreen

    run or test pl/sql from PC

    The developer's in my group have loaded the 9i database on there PC's. They then loaded the schema that contains one of our PL/SQL applications. They want to make changes and test them. What do I need to load on there PC in order for them to test the code changes in a web based environment from...
  15. thomgreen

    Connect to MS share from solaris

    the app seems really cool but... I do not believe that it will allow me to mount the share in solaris. I have heard of 'sharity' - do you know if this product will allow me to not just view the share but mount it as well.
  16. thomgreen

    Connect to MS share from solaris

    is there a way to mount a NTFS file share on solaris 8?
  17. thomgreen

    disable 9ias web cache

    Thanks. I actually modified the port in httpd.conf from 80 to 7780.
  18. thomgreen

    disable 9ias web cache

    please inform me on how to disable the 9ias webcache and directly users right to the http server. Any info would be appreciated.
  19. thomgreen

    Outlook problem - Inbox redirect

    I am having a problem with my inbox in Outlook Pro. For some reason ALL of my emails are going into my INBOX and then automatically moved to my JUNK E-MAIL. I did not knowingly make changes. Any idea on how to remedy this issue?
  20. thomgreen

    9ias integration with Siteminder

    Has any one successfully implemented siteminder into 9ias Version 2? I have been working with Siteminder support and Oracle support and no one seems to be able to get this working. If you have experience with this please reply with documentation on how this implementation was successful.

Part and Inventory Search

Back
Top