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!

Register Log in
  • Congratulations IamaSherpa 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: *

  • Users: Murt
  • Order by date
  1. Murt

    importing a *.dmp file from 9i DB to 8i

    Yes, IMP and EXP work perfectly against an 8.1.7 database. It fails against 8.1.6 with 904 errors but exp is not backward compatible anyway so this doesn't bother me. At least I now know that it is possible - I was beginning to wonder !
  2. Murt

    importing a *.dmp file from 9i DB to 8i

    Hi, I am running Windows 2000 on my PC, 8.1.7 client is correctly installed and configured. I can connect to any database (8 or 9) thru sqlplus but exp bombs out even if run from the bin directory. The 9i DB I am connecting to is 9.2.0.1.0 running on Solaris. I have also tried using exp on 2...
  3. Murt

    importing a *.dmp file from 9i DB to 8i

    Has anyone successfully imported from 9i to 8i ? Everything you say makes sense about using the 8i utilities for both export and import but in practice it won't work for me ! With 8.1.7 exp bombs out with a windows error "EXP.exe has generated errors and will be closed by Windows. You will...
  4. Murt

    making a column optional

    thanks for that. Unfortunately that doesn't work for DB2 version 7 running on linux. Oh well !
  5. Murt

    ORA - 00001

    The only thing I can think of is that there may be a trigger on the table that is executing with the update. Check user_triggers or dba_triggers Murt
  6. Murt

    making a column optional

    Thanks for that Marc. I was hoping there was a way to just change the column characteristic as you can in Oracle or Sybase. Oh well ! Cheers, Murt
  7. Murt

    making a column optional

    Hi I am new to DB2 and have a fairly basic question. I have a mandatory column (NOT NULL) in my table. How do I alter the column to be optional ?

Part and Inventory Search

Back
Top