It is possible to move Oracle index to another tablespace.

It is possible to move oracle index like tables.

alter table tab move tablespace blabla;
alter index tab_index rebuild tablespace blala;

How to find readable time difference bettween Oracle date types?

It is not crucial, but it is cool. This way you can find time date/time difference nicely.

SELECT

lpad(EXTRACT(HOUR FROM(dend_date – dstart_date) DAY TO SECOND),2,’0′) || ‘ hour ‘ ||
lpad(EXTRACT(MINUTE FROM(dend_date – dstart_date) DAY TO SECOND),2,’0′) || ‘ minute ‘ ||
lpad(EXTRACT(SECOND FROM(dend_date – dstart_date) DAY TO SECOND),2,’0′) || ‘ second ‘ “Interval”
FROM process_log
order by dstart_date desc;

ref::Oracle® Database SQL Reference
10g Release 2 (10.2)
B14200-02

CMD.exe pre-configuration

It is well known that Oracle-sql*plus can be configured with a login.sql file preferably placed under same directory of sql*plus. But what about cmd.exe on Windows.

HKEY_LOCAL_MACHINE\Software\Microsoft\Command Processor\AutoRun
and/or
HKEY_CURRENT_USER\Software\Microsoft\Command Processor\AutoRun

if you edit AutoRun key with a file address (i prefer-> c:\initial.bat), cmd.exe executes that file firstly. this way you can configure your regular work automatically.

Hello World

it is a classic. But i find no other way to start.

#include <stdio.h>
int main(void)
{

printf(“%s”,”Hello World\n”) ;
}