Search Results

After running the query above I get the following error:
MESSAGE_TEXT - The SQL database operation failed.
APPENDED_TEXT - ORA-00913: too many values
ADDITIONAL INFORMATION - update t1533 t...

Here is my select that I have to identify the child records that are Open (e.c7 < 6000) when the parent (t2068) c.c7 > 3


SELECT c.c1000000161,
c.c7,
c.c1000000019,
...

Thanks for the explanation. I am not an Oracle DBA and didn't realize that deleting multiple gigs of data at the same time will impact the redolog unless we delete 1000 rows and commit and repeat...

Oracle

---------- Post updated at 01:27 PM ---------- Previous update was at 01:26 PM ----------



Compressing should be good. It is not as shrinking the table right?

I have a table in one of my DB. The DB is about 300 gig - of that 249 gig is in this table. The data is somewhat important but even if we delete half of it won't affect anybody.

I would like to...

Thanks for replying. This is what I have:
I have 2 db entries in my Oratab file but those DB don't exist anymore. I was under the impression that Oratab gets updated automatically when you create or...

Hey there.

Well there is already an Oracle Home in my environment but It's looks messy (means all the files all over the place) There is dbhome_1 in 3 different location (copied to a different...

I am wondering if I can get some help here.

I am deinstalling Oracle home on solaris. Downloaded deintsall zip file from oracle and then ran ./deinstall -home (Full Path)

10 seconds later I get...

Thank you Sir.

Thank you so much for being so helpful. I will start the installation process and will get back to this form if I run into any issues?

Thank you all for help.

Thanks you so much for replying. Just wondering about the syntax of running installer and dbca in a silent mode? Can you provide me with the syntax if you don't mind?

Thanks again.

I am trying to read as much as I can (seriously) but Oracle is not as simple as it sounds or maybe it is but not for me. I also have a new thread regarding some of the issues I am running into when...

Everytime I run dbca or runInstaller I get this warning.

Warning: Cannot convert string "-monotype-arial-regular-r-normal--*-140-*-*-p-*-iso8859-1" to type FontStruct

I googled it but there are...

I ended up downloading Oracle client 11.2.0 and installed it on Solaris where application is installed. Please bare with me since I am fairly new to oracle and don't know even 2 % about it. Questions...

What I am trying to do is install Remedy on a Solaris machine. However to install Remedy on Solaris, the server has to be able to connect to the oracle database on the Linux server? How can I...

I am wondering if someone can help a brother out. I am trying to create a DB using a GUI and when I am about to finish, it gets stuck. I hit finish but nothing happens. Any help from the community...

Thank you all for your reply. I don't think I will delete anything. I ended up making some changes in the profile and God know what else I did. Long story short I will just create a DB which I am...

I think you are right, I don't know how different will it be next time since I am no expert.

1) I don't have to deinstall/delete anything if I can get a little push. What's confusing is there are...

How can I deinstall or delete the whole environment and delete everything (all the files, group, users). I would like to start fresh. I 'd like to install ORACLE 12c. Create users from scratch,...

It worked. I logged in as root and typed env and it gave me this:
BMC_SLM_JAVA_HOME=/usr/java
CATALINA_HOME=/space/home/apache-tomcat-5.5.23/apache-tomcat-5.5.23
DISPLAY=localhost:10.0
EDITOR=vi...

awk '$0 ~ /^root/' /etc/passwd
root:x:0:0:Super-User:/:/sbin/sh

cat /.profile
#
# Initial EIS settings for user root
# This file is set up by the setup-standard script.
#
# In the unlikely...

This is what it looks like now:

#ident "@(#)profile 1.19 01/03/13 SMI" /* SVr4.0 1.3 */

# The profile that all logins get before using their own .profile.

trap "" 2 3
export...

This is what I have in my /etc/profile: I have no idea what I am doing or what I need to do: I do appreciate the fact that you guys are trying to help me out so much.
This is my Oracle home:...

Which profile should I change?
I already changed 1 profile when I logged in as Oracle.
Do all the users have different profile which needs to be updated with the Oracle Base and Oracle Home?

(I...

. .profile
.profile not found

---------- Post updated 04-24-14 at 09:08 AM ---------- Previous update was 04-23-14 at 02:34 PM ----------

This is what I did. I logged in as Oracle and changed...