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 Chriss Miller 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. sybaseguru

    How to load csv file into table?

    Use bcp and set the batch size like below bcp <data_base>..<table_name> in <file_name> -t, -U<user_name> -S<server_name> -P<password> -b<batch_size> For example with -b1000 will commit every 1000 records so your transaction will not fill in. Obviously you can change the -b size Good luck
  2. sybaseguru

    Hot backup question

    Loiusa, In answer to your question, On-line or hot backups can be done on the entire Oracle database or a single tablespace in Oracle. You can only do a hot backup when the database is in &quot;archivelog&quot; mode. That is you are backing up your redolog or transaction logs. when a...
  3. sybaseguru

    how to check a MEMO (text) field is empty?

    Yes should be OK. But do not forget that &quot;not&quot; is slower than others
  4. sybaseguru

    how to check a MEMO (text) field is empty?

    for text fields you can only use like comparison. See below: 1> create table abc(col1 int not null, text_field text null) 2> go 1> insert abc values(1,null) 2> go (1 row affected) 1> insert abc values(1,'some text here') 2> go (1 row affected) 1> select * from abc where text_field is null 2>...
  5. sybaseguru

    Conflict resolution on advanced replication

    Hi MDatHome, What sort of replication are we talking. Is this peer-to-peer or bi-directional replication and are you specifically want info about collisions which create business integrity violations. For example two traders creating the same trade with unique ID at the same time on two...
  6. sybaseguru

    adding datafile to a tablespace

    Yes of course, that is the whole idea. Just do alter tablespace <tablespace_name> add datafile '<datafile_name>' ...
  7. sybaseguru

    The future of Sybase

    JeanNiBee, I am glad you joined the future forum. You may get some of my e-mails. My name is &quot;Mich&quot; and I am the chairman of that forum. If you are member of that forum,please take part actively and let us hear from all you.
  8. sybaseguru

    selecting current date

    mannymo, For a complete explanation of date conversion, see ASE transact sql guide for &quot;convert&quot; function. In short, convert function can display the date in the format you want passeing the value. Have a look at below for a complete list of display values in...
  9. sybaseguru

    Adding a field in oracle with a unique identifier

    ashcarrot, If you are coming from MSSQL or Sybase background you can do this using an identity column. In Oracle you can create sequences. However, because of the way commit works in Oracle you may end up having gaps or a wrong order in sequence. If you want to have absolute control on this you...
  10. sybaseguru

    How to generate script from database

    patr1q. As colleagues pointed out above &quot;export database&quot; will provide you with all you need. The <database>.dmp file produced is a binary file. If you are working on UNIX you can easily extract the user creation and grant section to ensure that the import will work. You can try the...
  11. sybaseguru

    ORA-27101

    Can you also tail -100 altert_dev920.log and send the output please.
  12. sybaseguru

    Clone Oracle 9i database on AIX box

    MCubitt, No sweat mate. You should be able to write a shell script to do the automated replacement for you for everything on the copy of generated trace file. I will try to have a go at it later on and post it.
  13. sybaseguru

    Clone Oracle 9i database on AIX box

    I have answered this question many times. But a general approach would be and by the way you can use UNIX &quot;sed&quot; command for replacing the lines in the sql file easiliy Decide on the name (SID) of the new database and create an associated parameter file to define the Oracle...
  14. sybaseguru

    Problem with spfile

    OK do not panic let us sort it out. First rename your pfile to pfile_old. Then although spfileCLM.ora is a binary file copy it to pfileCLM.ora and use vi to edit it. Remove the first and last line of entries (just do 'dd' on the line). Then remove the parameter that causing the problem. Once...
  15. sybaseguru

    Select last 100 rows

    What do you mean by last 100 rows. The way data is stored in Sybase depends on the clustered index created on the table or the identity column if you have included in the table or just a heap table. In either case the unique index or identity column will allow you to select the last most...
  16. sybaseguru

    SPOOLing from SQPLUS within UNIX script

    What do you need all that. On UNIX just try sqlplus /nolog @/home/oracle/IFSTtoIFSD/shutdownIFSD.sql > output.log Gives you the flexibility to write a proper shell file as well
  17. sybaseguru

    first day of the month

    Hi, I do not think there is a function for it. This one does last day of the Month so you can work out the first day of the month from it select TO_CHAR(TO_DATE(TO_CHAR(ADD_MONTHS(SYSDATE, 1), 'MM') || '-01-' || TO_CHAR(ADD_MONTHS(SYSDATE, 1), 'YYYY'), 'MM-DD-YYYY')-1, 'dd-mm-yyyy') from...
  18. sybaseguru

    selecting current date

    do sp_help history_master and send the output here
  19. sybaseguru

    How do I add/drop controlfiles while database is running?

    Yes I believe shutting down the database, using mv command to move an existing control file to a new location, modifying the init.ora file to reflect the new control.ctl location and restart of the database is the only option for now. Sorry about the bad news
  20. sybaseguru

    selecting current date

    Try this select date_index from history_master where date_index = getdate()

Part and Inventory Search

Back
Top