when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1660

what are the differences of where and if in SAS?

2133

how can you get actual data change values from previous transactions in oracle?

1034

How would you best determine why your MVIEW couldn't FAST REFRESH?

2293

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1936

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

937

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1919

how can you connect from 10g user to 11g user??

2061

What is the default fill factor value? : sql server DBA

1058

What is transparent data encryption? : sql server DBA

1114

Why does Oracle not permit the use of PCTUSED with indexes?

2879

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2743

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

932

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1050

What is the importance of a recovery model? : sql server DBA

966