I want to create synonym for table emp but in my pc it is
giving insufficient previliges.I am using user scott.Please
suggest me.
- 3 Answers
- 5550 Views
- I also Faced
- E-Mail Answers
Answer Posted / meher
do login as sysdba and create the synonym.
you dont have privileges to do the same from scott user.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What do you know by pl/sql cursors?
What is anonymous block in sql?
Is natural join and inner join same?
Differentiate between pl/sql and sql?
What are analytical functions in sql?
Why function is used in sql?
What is sql query limit?
what are the drivers in mysql? : Sql dba
What is not in sql?
How does cross join work in sql?
How much ram can sql express use?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What are records give examples?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
