Data Conversion

load data infile 'file.txt' append into table <table> ( some1 position(*) char terminated by ';', some2 position(*) char terminated by ';', some3 position(*) char terminated by ';' ) sometimes when run it look like freeze. what can be problem? tnx

set ORACLE_SID=DB2 shutdown immediate; exit delete all files from folder oradata\DB2\ set ORACLE_SID=DB1 alter database backup controlfile to trace; shutdown immediate; exit copy all files from folder oradata\DB1 to oradata\DB2 in oradata\DB2 directory delete all control files control01.ctl control02.ctl control03.ctl

Daily Download

Daily Download

Dear all, ...

Here is the first of a series of blog posts that I am putting together to share where some of my excitement comes from for the upcoming trip I will be doing to Berlin to attend what I think is one of the best Social Computing events taking place this year in Europe: The Web 2.0 Expo! Will you be there? Here you will find as well how I can help you get there! Read on ...

A Bloor Analyst report came out last week that discovered doing data integration quick and dirty with cheaper tools saves money.

Our company is planning to uprage from oracle 9i to 10g. I want to know what all problem i will face during upgradation..

“Convert to Hindu religion or face eviction from your land” Indian Muslims, CA - 8 hours ago

OpenOffice.org 3.0 Promises New Life for Office Software OStatic, CA - 6 hours ago

I'm getting a load of "page not found" (404) errors while trying to access 10gR2 documentation. Anyone else having problems? -g

Hi all, what is the fastest way to restore an oracle db? I'm using impdp but it's really slow compared to other databases tools (for example db2 restore command) the command I'm using is something like: impdp fx2/password@teng REMAP_TABLESPACE='FXTS':'FX2TS ' directory=dump PARALLEL=2 dumpfile=fx_dump.dmp REMAP_SCHEMA=fx:fx2 NOLOGFILE=Y

We are using Oracle 10g and would like to create a report that show how often a column is used or atleast a table. I've been looking at the SYS views but not sure which one to use.

Hello group, I've got a table with roughly 7 million rows in a 10G database. When I query it like that it returns results in about a second: SELECT * FROM VERM WHERE 1=1 AND VER_DAT >= to_date('20.07.2008','dd.mm.yy yy'); The plan looks like this: SELECT STATEMENT ALL_ROWSCost: 11,111 Bytes: 210,924 Cardinality:

Car part hot item for thieves Daily Triplicate, CA - 5 hours ago ... that uses his service on file .

Don't Let Funny Things Happen on the Way to Your Forum! Protect your community by creating and posting guidelines for use.