IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

October Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data Board     Print This   

Oracle Topic

Database design, admin, PL/SQL, forms, etc.
  


10 Threads:

Add New ThreadRandom Thread

Thread 10 of 10
Thread Starter  

STRUCTURED2000
Oracle Management server (OMS)
Please, help. I'm new to Oracle 9i. I pracyice on my XP homet home trying to log in to enterprise OMS. I installed Oracle 9i, login to Enterprise OMS. When I logged off and turned off and on the computer, my login effort is unsuccesful and if I reinstalled my XP OS again and reintall oracle 9i, I will be able to login to enterprise OMS but once I turned off and restart my computer, I'm out. Do you have a clue what's going on., Thank you.
11 years ago
1 Reply:

adamlum
Have you made sure the Oracle service is starting when you reboot and log into Windows? It should be set to automatic so that it will start up on it's own.
7 years ago
Nothing New Since Your Last Visit
2686
Hits

Thread 9 of 10
Thread Starter  

Marine1
Homework help
Hello,, , Need some homework help on databases such as, creating an ERD, data sets and so on. This stuff is bit over my head just need to survive at this point. I just don't the brain at this time for Oracle SQL. Thanks., , Until that time...
10 years ago
1 Reply:

adamlum
Any specific question at the moment, what can we help you out with first?
7 years ago
Nothing New Since Your Last Visit
2596
Hits

Thread 8 of 10
Thread Starter  

rrs
Linking to Oracle
I have problems when I try to link to Oracle table. I get an error message "Invalid field definition 'Field Name ' in defnition of index or relationship"., The table I am trying to link to is really big. It has around 260 columns Could that cause a problem ? , Thanks for your help.
11 years ago
1 Reply:

Scott
{Too Long}
11 years ago
Nothing New Since Your Last Visit
2439
Hits

Thread 7 of 10
Thread Starter  

snow_boy
Delphi 6 and Toraclequery.
hi.. I am still a beginner in the delphi programming. so I am just wondering if anyone can help me with a problem that I have. I am current using DOA(Direct Oracle Access), by using that I want to get a procedure that are in the oracle server and use it in my program. I have use the TOraclePackage and in it there is a component "callprocedure" and "callFunction" well I know how to use them and all.. but I am having great trouble of declaring them. , I also have use the TOracleQuery, but it is the declara in the SQL editor that annoying me. coz it gave me error message and etc. so if u can help me with the SQL declare and that will be great., , , thx in advance, Billy
12 years ago
Nothing New Since Your Last Visit
2785
Hits

Thread 6 of 10
Thread Starter  

NewNewbie
Databases on different Platforms
Hi!, I have a question... I have a DB2 database on the IBM mainframe, and a ORACLE database on a Sun box. Guess what? These 2 different databases have duplicate data in some of the tables. How would you go about elimiating this duplicate data and keeping these 2 datbases in synch? Is there a way that when the DB2 table gets updated, you could immediately fire off an update transaction in ORACLE? Can't you do this with CORBA? I have no idea what I'm talking about... Can anybody offer me some suggestions??, , Thx! , Eek!
13 years ago
Nothing New Since Your Last Visit
1335
Hits

Thread 5 of 10
Thread Starter  

laurent
Run Time error 40002. ORA-01013
I have a run-time error 40002 when running an application (VB5). This is the following message I have when a selection query (with 9 joins):S1T00:[Oracle][ODBC]ORA-01013: user requested cancel of current operation., The query takes, wheter with ODBC test or Sql+, 5 minutes to be executed. This is too long for a user who is waiting for a result. was wondering if there are otpions to set, or optimization rules or paramters to set., Thanks for any answer., Laurent
13 years ago
2 replies. Last post:

sgeorges
Thanks Pedro! I have found a solution. I have just added after the SELECT /+ * ALL_ROWS */ and the query works fine
13 years ago
Nothing New Since Your Last Visit
5989
Hits

Thread 4 of 10
Thread Starter  

Guardian
Best bang for buck Oracle Book
Looking for advice on a good Oracle book to cover system administration (as well as setup, design, backup and recovery, exporting, etc) and programming tips (mainly in Java and PL/SQL, although others would be fine as well). I have Oracle Personal Server 8 running with a small test database I created, along with Oracle Forms and Reports 6 with some simple forms and reports accessing it, so I have the tools to play with, I just want some 'direction' with which to improve my skills., , I have some database design experience, as well as Oracle Forms and Reports experience. I also work in Java, so I'm not looking for a beginner's book, Intermediate to Advanced would be best. Any suggestions would be appreciated!
13 years ago
Nothing New Since Your Last Visit
1207
Hits

Thread 3 of 10
Thread Starter  

seenu
How to get the next message
I have the following data as output., , First Message [ mesg id = 0], Re : First Message [ mesg id = 4 ], Re Re : First Message [mesg id = 6], Second Message [ mesg id = 2], Re : second Message [mesg id = 3], Re Re : second Message [mesg id = 5], , When i am in Re : First Message (ie mesg id 4) i want to jump to the Second Message ( ie mesg id = 2) when i click a next message button. , , How should i write an sql query for that., , Cany anyone please please help me out??, , Thanks, Seenu
13 years ago
Nothing New Since Your Last Visit
1206
Hits

Thread 2 of 10
Thread Starter  

andreK
Export a Fixed Length AScii file from Oracle
Apart from using an export utility, is there a way to export a file to ascii format, fixed length using sql. I would like to wrap this in a stored procedure., , , Thanks, , Lans
13 years ago
1 Reply:

Scott
{Too Long}
13 years ago
Nothing New Since Your Last Visit
2399
Hits

Thread 1 of 10
Thread Starter  

Mike Prestwood
Welcome!
{Too Long}
14 years ago
Nothing New Since Your Last Visit
1213
Hits

New Thread
-
  Load Time=less than 1 second.
 
Print This
-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


-
 
Connect With Us...
PrestwoodBoards
Join Us!
Facebook
Like our page!!!
Twitter
Follow us!
LinkedIn
Join Group
YouTube
View channel.
Go ahead!   Use Us! Call: 916-726-5675 


©1995-2014 Prestwood IT Solutions.   [Security & Privacy]   Made in the U.S.A..   No H1-B.   No offshoring.