Hi
I am trying to change SYS password
alter user sys identified by admin;
When I try to login using new password it it says invalid username. I am trying to login as sysdba. and it is...
Hi,
I am trying to connect from SQL + mode to the database, but I am getting the following errors as per the attachments and unable to connect.
When I installed the Oracle 10g software, ...
Yes, this is right.
Create table original
create table new as select * from original.
and then rename table new to original.
But in case I used constaints like primary key , reference key ...
I would like to calculate how much actual disk space will my database use (I know how many rows I will have, I need maximum size on disk). Is it enough to take the column size attribute and ...
Hi all,
I have a view I am trying to create using TOAD, or SQL Plus for that matter. I get the error message: Error Creating View: ORA-00933: SQL command not properly ended If I just ru...
I am doing a trade study in which I am comparing TOAD with Oracle 10G OEM. One of the key areas is can TOAD manage and automate your backup and recovery requirements? Can it interface with RM...
Please provide me document for Oracle Financial Implementation for R12 for AIX.
Thanks
I would like an explanation of some of the columns in the V$RMAN_STATUS in release 10g.
I need to find the success or failure of a full or archive log backup for all DBs using a particular...
Hi,
I have to connect and transfer large set-of data from Oracle 7.3.4 to Sql 2005 in scheduled manner. i know Oracle Ado.net provider will not support to comunicate with oracle 7.3.4 serv...
I have the following SQL Statement:
Select ID FROM EMPLOYEE where office = 'CA'
The results return the following record:
ID = 15, 20 , 30
How do I use this output on anothe query?
...
Hi,
Im using Oracle 10 g and sql talk for windows
The query can work with a case statement, but have to convert my SQL to use the DECODE statement.
I would like the decode to use logi...
Hi all,
How to find the size of the index? can any one can explain me.
I have a query I run as a script by dropping a tmp table, creating it, inserting rows in it, and then run a query from it. How do I create a view out of this?
What privileges does DBA_TAB_PRIVS contain? I read that it can be used to find all grants to a particular table but I don't find one table that I created.
Does it only list explicitly granted...
Hi,
I need help to write a query to pull data on the last night that have been entered in the table .
The table transaction structure is as following:
Name ...
Hi,
SELECT ename, job, TO_CHAR(MONTHS_BETWEEN('O1-JAN-81','31-DEC-81'), 'MM/DD/YY') HIREDATE, CONCAT(CONCAT(ename, job),' ,') EMPLOYEE
FROM emp e
WHERE ename >= ALL
(SELECT ename
FRO...
I need to perform a select and manipulate the where clause like so:
SELECT * FROM MY_TABLE WHERE MY_TIMESTAMP = CURRENT_DATE - 1
the date being at the level of a DAY (not hours or whatev...
Hello i wana do basic crontab for RMAN. here is my script :
#!/bin/bash
/bin/su - oracle
export ORACLE_SID=pp1
/oracle/10gR2/bin/rman CMDFILE='/oracle/RMAN/pp_script' LOG='/oracle/RMAN/...
Hello,
Here's what i'm trying to accomplish. I would like to create a trigger which will monitor record deletions on ANY table inside a certain schema and send an email with record details...
I need to write a query which will be joing both the fact and dimention table by account level to get the amount which is stored by group level (detail).
I've no problem writing a query for t...
Hi there,
I cannot start Oracle XE in my Ubuntu Linux. I don't know what's going on. It worked just fine yesterday. I ran the following in the Linux terminal:
jazon@localhost:~$ cd /u...
HI. First of all, sorry for my English, i will try to explain my problem....
I have two views. They are based on two tables each one.
In my Form there is two blocks. typicall master/detail...
I always wondered why simply copying Oracle data files to another machine is not sufficient to make Oracle work. Consider Microsoft SQL Server, in case you need to attach an existing database ...
Hi,
Can I have 2 entries int he tnsnames.ora for the same service name? (In other words in the following tnsnames.ora after the horizontal line like the last entry, can I have an additiona...
Is there an easy way to get the used tablespace per user. So which query do I need to run to get get used tablespace for say user Scott. Additional is there an SQL to get the TOP 10 used table...
