Search results for query: *

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

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

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

...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> go Msg 306, Level 16, State 1: Server 'SYB_CRIDR1', Line 1: TEXT and IMAGE datatypes may not be used in a...

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

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

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.

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

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

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

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

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.

...of the database, and change CONTROL_FILES to contain the location of the new associated Oracle controlfiles. This is very important 1. Using SQL*Plus or anything else connect to the source database and issue the following command: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; This command...

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

...the last most recently inserted records. For example if you use the identity column and you called it &quot;col_id&quot; in the table do select * from <table> where col_id >= (select max(col_id)-100 from <table>) Otherwise you can do set rowcount(100) go and choose the first or last 100...

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

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

do sp_help history_master and send the output here

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

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