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

How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  

---

What is the difference between having clause and where clause?

0 Answers  

---

What is dynamic sql in pl sql?

0 Answers  

---

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

What is fmtonly in sql?

0 Answers  

---

Explain aggregate functions are available there in sql?

0 Answers  

---

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,

---

What is a parameter query?

0 Answers  

---

how is myisam table stored? : Sql dba

0 Answers  

---

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

---