Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / June 2009

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Anyone using nagios?30 Jun 2009 09:11 GMT4
If so what do you think about it?
Are you using it only on linux systems or across multiple unix systems
or ... ???
How useable is the alerting and monitoring?
physical standby database on other platfrom??30 Jun 2009 00:46 GMT5
 I need to know there is any possible way to create standby database on
other system platform than production database.
example : prodaction is on linux and standby will be on windows
Reagrds  - MJ
initial value on create table/index statement29 Jun 2009 22:55 GMT11
Is there a way to change the value of "inital" in "create table" or
"create index" during imp?  Pre-creating table is not an option here.
I am taking a export dump with rows=n from production and importing it
into dev/QA and since the production tables/indexes have larger values
Strange behaviour of Cramer query29 Jun 2009 19:43 GMT8
OS: Solaris 5.10
Oracle: 10.2.0.2
Application: Cramer see  http://en.wikipedia.org/wiki/Cramer_Systems
I was ask to look at a performance issue on a database used for
RMAN Recovery28 Jun 2009 15:23 GMT3
We had a developer make some changes to production.  Idiot.
Anyhow, we have a complete backfrom from about 9:00am.  There were
some changes arounf 12:00 which are fine.  The developer made changes
at 3:30 and messed everything up.
"How to find a job that makes you over 300K in software development"26 Jun 2009 23:17 GMT2
Attention Developers
At last! Here are the (long overdue) tips and tricks you've been
waiting for. Check out this new contrarian special report that reveals
secrets of industry's highest paid programmers - the secrets you can
COUNT(...) OVER(...)26 Jun 2009 18:59 GMT3
I'm trying to learn about analytic functions, more specifically the
OVER() clause applied to COUNT() and AVG() functions. I've read the SQL
Reference and I've found several examples in Google but I still can't
grasp the concept.
UNDO Issue26 Jun 2009 13:22 GMT14
We're receiving this message:  . .
importing table          "DAILY_CONSENSUS_HST"
IMP-00058: ORACLE error 30036 encountered
ORA-30036: unable to extend segment by 8 in undo tablespace
REGEXP_SUBSTR() is always NULL26 Jun 2009 08:23 GMT6
In an Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 server,
REGEXP_SUBSTR() always returns NULL. E.g.:
SELECT REGEXP_SUBSTR('1234,5678', '\d+', 1, 1)
FROM DUAL
Data type changes using ODBC...25 Jun 2009 09:26 GMT2
I am using Oracle ODBC to connect tables from an Oracle schema to an empty
Microsoft Access DB.
In one particular table i have a VARCHAR2 field that is 255 chars long.
This field is reported as being of MEMO type in Access, which is untrue.
Why I cannot do select on other's tables even when I have DBA     privileges24 Jun 2009 22:42 GMT13
I have dba privileges; My database has users user1, user2…
When I enter
Select * from user1.table1
I get an error table or view does not exit,  I am pretty sure table1
[Oracle 9i] Is the script is the same as the interactive mode?24 Jun 2009 17:49 GMT2
I need to create a script exporting the database in exactly the same way as
in interactive
Exp in interactive mode:
 $ exp database_user/******
Oracle reports 6i24 Jun 2009 11:43 GMT1
Learn Oracle reports in 2 days...I have described fully how to develop
the reports..
Airlines24 Jun 2009 11:34 GMT9
Site contain very much information about airlines inclouds coutry
wise
airlines companies informations and video see this
# Pakistan Airlines
Remove dupes with CLOB columns involved23 Jun 2009 17:10 GMT6
I've created a GLOBAL TEMPORARY TABLE where one of the columns stores
the result of concatenating a variable (and unknown) number of
VARCHAR2(100) cells. I didn't want to hit the 4,000 character limit when
the source table has more than 40 rows so I created such temp column as
Pages: 1 2 3 4 5 6 May, 2009
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.