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

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

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.

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

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

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

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()