19/07/2018 11:47
Hi! I have a question. Given three MySQL-InnoDB tables: images -> id | imageSrc | imageTitle | foreignGroupIdimageGroup -> id | groupNameimageTags -> id | foreignImageId | tag ... how would I join-select an imageSrc and its groupName if I wantall images which have both the tag foo and the tag bar (but notjust either tag -- just looking for exclusively those images with bothtags)? Thanks!

3 answersclick here to view

18/07/2018 11:47
Hi there! We have a problem. We are converting data of a database to an oracleenvironment. Therefore we have a production server (win 2000 4processors, a bulk of memory) and a test server (win 2000, only oneprocessor, less memory). The production server should be faster thanthe test server.
We wrote lots of scripts on the test environment and this all was ok.
But now we're trying the scripts on the production server and it allworks very slow.
For testing we copied the production db to the .... read more

3 answersclick here to view

17/07/2018 11:47
I am locked out of mysql server. I can connect but in phpmyadmin Idon't have permissions to create a database. I started up skippinggrant tables but I got this message. The data directory is set forread write and execute for _mysql user. I have a _mysql user and amysql user on the Mysql db. I didn't know I had an Innodb but I mighthave a test one. What does it want me to do now at the prompt. Isthere a problem with the socket path? What do I do to add a passwordfor a user on the.... read more

4 answersclick here to view

16/07/2018 11:47
Hi group, Sanity check. 1. There is no way to assign a rollback segment to a 'session', right?2. It does not matter whether update or select comes first, ORA-01555can potentially happen, rihgt? Thanks.
John

8 answersclick here to view

13/07/2018 11:47
I have a need to query records from a Sybase database running on Linux(32-bit) and am using Oracle 10.2.0.3 with generic connectivity (nospecific heterogeneous service for Sybase on Linux). We have installedan ODBC driver on the Oracle server and can query the Sybase databasewithout difficulty except for outer joins.
I have tried using both the Oracle syntax and the ANSI syntax. Bothreturn results that are consistent with using an inner join. The ANSIquery, run directly against the Sybase datab.... read more

2 answersclick here to view

12/07/2018 11:47
Hi.
I am running XP Pro.
I have Oracle 10.1.0.2.0 installed.
I had installed a new database (sid?) recently about a gig in table spacesize.
I noticed that now my machine just 'cranks' the disk drive for about 15minutes and it is so relentless that my pc is pretty unusable for that initialstartup period of time.
I did a ctrl-alt-delete to look at task manager and saw that oracle and javaseem to be near or at the very top of the cpu consumption, though I realizethat is not necessarily i.... read more

1 answersclick here to view

11/07/2018 11:47
I want to build a simple message board, and display the messages as threads using nested HTML ul tags I plan to use PHP and have found numerous tutorials and ready to run scripts, but want to make my own. I'm having trouble clearing the cobwebs enough to figure out how to design the MySQL tables so I can track threads. In several examples they have a topic table and a reply using ID to relate them. Where I am getting myself lost is how to relate several generations i.e. topic -> reply.... read more

5 answersclick here to view

10/07/2018 11:47
Hello, This question is a bit tricky and to the compilance of sox. Thanks.
I created a procedure under x schema in database A and want to executeit from database B under y schema.
How to work it out without grant execute to public? Thanks in advance.
Mike

4 answersclick here to view

09/07/2018 11:47
All, Is there one simple query that could be used to search all tables inthe dictionery to find every occurance of the value...let's say xyzor the number 25.
Thanks,Jack ps. you can probably tell I don't know squat about SQL

6 answersclick here to view

08/07/2018 11:47
Hi, I am an Oracle Certified DBA with over 10 years of development anddatabase administration experience. Very strong on the Databaseconcepts, developer6i and extremely good at business functions.
I would like to shift my career as an Oracle Apps DBA and hence amtaking classes on Oracle eBusiness suite essentials (implementer andTechnical consultant).
Could anybody tell me how to make an entry into the eBusiness suiteworld.
Thank you in advance.

4 answersclick here to view

07/07/2018 11:47
Hi group Sorry if this is a cross post - in fact I lost my connection whileposting..
I need to create an 8i database on a win2000 server remotely. I triedtelnet, created an instance but when trying to connect using startup nomount pfile=E:oracleadminow3ppfileinitow3p.ora it throws error LRM-00110: syntax error at 'upward'ORA-01078: failure in processing system parameters does it have to do something with OS authenticatioin ? I even triedVNC but that does not even allow me to connect - .... read more

2 answersclick here to view

06/07/2018 11:47
Hi does anyone have an example command line syntax command for importing a delimited flat file with a delimiter into mysql ?? Also, does anyone have insight into this - I tried to use TOAD to import, but there is this String Quote Character entry which does not allow import of single quotes if you enter a single quote - does anyone know what to put in this entry ? I tried { and it seemed to work but this is a strange requirement.
Thank you, Ben

1 answersclick here to view

05/07/2018 11:47
Hi, I have a table with a column of the following type: bigint(20)unsigned. The name of the column is id. The table has 20 rows andfor every row the value in the id is unique. Is that possible tomake my id column to be primary key. And, if yes, how? Thank you in advance.

1 answersclick here to view

03/07/2018 11:47
Hi anybody,I was getting error like below while compiling packageORA-04021: timeout occurred while waiting to lock object start1.stplease assist me.

6 answersclick here to view

02/07/2018 11:47
Hi ich habe eine Oracle 9i installiert. Auf der DB soll eine Webanwendunglaufen. Der Code f=FCr die Anwendung ist ok. Hab schon =FCber SQLPlus dieZugangsdaten gecheckt und die gehen alle.
Bekomme aber dennoch die Fehlermeldung 0RA-12637 Abruf desBerechtigungsnachweis misslungen Was und wo muss ich was in der DB einstellen?? Bin bei Oracle einNewbie.
thxThomas

4 answersclick here to view

eDiscover
Helpforce eDiscover provides technical articles updated each day
Click the logo to go back to the main page
Databases

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.

Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS