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

    Adding Another Datafile

    ALTER TABLESPACE "TBLSPCE_NAME" ADD DATAFILE 'D:\DATABASE\MY_DATFILE2.ORA' SIZE 100M;
  2. rossman

    Initial extent size when creating a table

    Hi everyone,<br>I'm getting rather confused now. When creating a table:<br>If I have a row size of 3k and estimated row count of 126,000 rows what would you recommend my initial extent, next extent to be? My max extents is 100 .If your answere is not around 4m could you let me know how you came...
  3. rossman

    Oracle Export Advice

    Do you want to export single schemas or tables? If it is the single schema you want to pull then the the par file should look like this<br><br><br>userid=system/password@&lt;tns_id&gt;<br>buffer=10000<br>file=&lt;pathto .dmp file&gt;<br>full=n<br>owner=(&lt;schema...
  4. rossman

    Data Migration - Rollback segments

    Does anybody know how to find out how large a transaction will be before the transaction occurs?<br>I am currently working with a team that is migating data from one system to another. The originating environment is Oracle 7x and the destination is Oracle 8x. I have set up different rollback...
  5. rossman

    Dual Monitor

    I know NT supports dual monitor cards, but does it also support dual video cards like Win 98? If so which service pack is it in or which utility should I install?
  6. rossman

    saving data from datawindows

    dwcontrol.SaveAs ( { filename, saveastype, colheading } )<br> Filename includes path and is a string c:\myfile.xls<br> saveastype is an enumerated datatype Excel! <br> colheading is true or false is there a heading or isn't there?
  7. rossman

    database connect.....

    Hmm... What Version are we talking 5.x 6.x or 7.x?
  8. rossman

    database connect.....

    I'm not sure what kind of database your connecting to so I'll give the cheat<br> <br> 1) connect to a valid database (the default is fine).<br> 2) Open database painter<br> 3) Open the Design then Options from the menu.<br> 4) Turn off &quot;Use Powersoft Repository&quot;<br> 5) Connect to...
  9. rossman

    Oracle 8 toolset

    I am trying to export an Oracle 7.3.3 Database with the Oracle 8 Data Manager. I can't figure out why it's not Working. I can use a 7.X Data Manager to export and import to a 8.5 Database. the big problem is I am developing a program which will be working with O8 but all my Current Production...
  10. rossman

    project build complaint.....

    TRY PUTTIN THE pbr FILE LISTING (PATH AND FILE )NEXT TO the application pbl path instead of in the reasource path box in the project painter.
  11. rossman

    Search using LIKE doesn't work

    Sorry I couldn't read the select statement. But I think you may get away with the % which is a Oracle wildcard. Just guessing
  12. rossman

    Importing a lost table

    You may have inavertantly imported to a different owner. log on as system or sys with the schema manager and search all the schemas for the correct table. export that table via the owner and import signed on as the actual owner of the table
  13. rossman

    Oracle 8 Toolset

    I am trying to export an Oracle 7.3.3 Database with the Oracle 8 Data Manager. I can't figure out why it's not Working. I can use a 7.X Data Manager to export and import to a 8.5 Database. the big problem is I am developing a program which will be working with O8 but all my Current Production...

Part and Inventory Search

Back
Top