Answer / sanjaya

STEP 1:
-------
OPEN SQL*PLUS
LOGIN AS
USER: SYSTEM
PASSWORD: ********

STEP 2:
-------
SQL> GRANT OLAP_USER TO SCOTT;

STEP 3:
-------
SQL> CONNECT
Enter user-name: SCOTT
Enter password: *****

STEP 4:
-------
SQL> CREATE [PUBLIC] SYNONYM <SYN_NAME>
FOR <USER_NAME.ABLE_NAME>;

Answer / meher

do login as sysdba and create the synonym.
you dont have privileges to do the same from scott user.

Answer / sreekumar

login as the user
create or replace synonym <<synonym_name>> for
object_owner.object_name;
or
any other super user like sys,sysadmin,etc can also create
sysnonymn for any schema.

Thanks
Sree
Oracle10g DBA

What is CYCLE/NO CYCLE in a Sequence?

2 Answers  

---

What is denormalization in a database?

0 Answers  

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

---

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

What does select top 1 do in sql?

0 Answers  

---

what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,

---

What is difference between inner join and self join?

0 Answers  

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

What are indexes, and what are the different types?

3 Answers  

---

Can we create clustered index without primary key?

0 Answers  

---

Can we use ddl statements in stored procedure?

0 Answers  

---

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  

---