Check any network modification parameters (firewall, networkcardsetting, switchconfiguration..).

We had mysterious errors about packets when

a firewall had extra ora_net filtering on (oracle)

tcp-offloading was enabled on a network card causing the ftp-server...

Thanks for the list, sofar on orafaq (forum) & dba-support (articles). How's OTN (Oracle Technical forum?)

No. Can't find the added value.

Have you added ; to the end of the statement?

SELECT one.pid

, one.Amount1OfSum

, two.Amount2OfSum

FROM ( SELECT pid

, SUM (Amount1) AS Amount1OfSum

FROM TableA

GROUP

BY pid...

Have you checked the table_name on casesensivity? tblUser<->TBLUSER.

It is possible to select from tblUser?

*Can't view the actual tablename in "reply"

Eventum[/url]

Free webbased-bugtracking abused as ticketing database. Flexible but not easy to report on.

Most people like to work from home/other room when they are interrupted too much or need a focus day, as most of the interruptions start with "Is person X here?"...

badminton, video games & going out

I'm in for the ease of use automatic tuning and learning capabilities of the database engine. More knobs are welcome in case the automatic goes awry.

Hopefully the files are compatible. Restore with files only is called "Cold Backup/restore"

Create a dummy Oracle instance with the same patchlevel as the original.

Shutdown the dummy instance.

Copy the files from...

Warehouse manager/computer logistics: keeping the computerprograms supplied with data.

not a necessity, depending on the nature of your transactions.

Transactionlog: value before/after transaction. If committed you could count it as changed

Diff=changed data since full (rolled back=not changed)

Are the patch levels of Access 2003 the same?

Is the application run on the local computer or is it virtualized (Terminal Server, Citrix,...)?

*have a look at

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_25175987.html

apart from the share permissions, does the agent also has the necessary NTFS-permissions (if underlying filesystem is ntfs)?

Recovery takes longer than the action itself.

The server has to read the transactionlog, apply the redochanges (which are logged also?).

To delete something from large tables it is benificial to do...