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

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

April 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
2616
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
2402
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
Moved from "Member Introductions"..., ,
, , The error message indicates that you have a [b]foreign key[/b] error, so you will find the problem in the foreign key definition., , , , If you have the metadata handy, check for column or table aliases. Sometimes the syntax of quotes around column aliases is OK for Oracle's interpreter, but when the metadata is exported to a development tool (VB??? Delphi??? Paradox???), the syntax is invalid in t...
11 years ago
Nothing New Since Your Last Visit
2342
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
2679
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
1300
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
5812
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
1151
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
1167
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
Let's assume that you are talking about exporting the data from the execution of a SQL script, using Oracle's SQL*Plus utility., , Whenever you execute a SQL query in Oracle SQL*Plus, the output is already formatted in fixed length ASCII. If you save your results to a file, you will see that there are fixed-length column boundaries in the output., , The Oracle SQL*Plus Reference has an entire section on custom-formatting the output of a query, u...
13 years ago
Nothing New Since Your Last Visit
2320
Hits

Thread 1 of 10
Thread Starter  

Mike Prestwood
Welcome!
Welcome to the Prestwood Message Boards. We're just getting started and this subject doesn't have any topics posted yet. Why don't you get us started and create a new topic (select the Post New Topic icon). Feel free to post your questions, tips, tricks, comments, and suggestions. I'll delete this temporary message as soon as a few topics get started out here., , This is a powerful message board. In addition to a main topic icon, you can use [URL=http://prestwood.net/ubb/smilies.html]icons[/URL] right in your text [IMG]http://prestwood.net/ubb/biggrin.gif[/IMG] - [b]HTML[/b] and the simpler [b][URL=http://prestwood.net/ubb/ubbcode.html]UBB[/URL][/b], codes work too. [IMG]http://prestwood.net/ubb/cool.gif[/IMG] Other advanced options include spell checking, email a message, searching, list today's posts, high-light new messages since your last visit (the light bulb), and editing of your own messages after you...
14 years ago
Nothing New Since Your Last Visit
1142
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.