Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6302 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 is scope and visibility in PL/SQL?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is a subquery in sql?
What is break?
How to call shell script from pl sql procedure?
what is the difference between join and union? : Sql dba
What are packages in pl sql and also explain its advantages?
How does rowid help in running a query faster?
What is dml and ddl?
What are the query optimization techniques?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What are the string functions in sql?
What is a primary key sql?
what is foreign key? : Sql dba
What is cost in sql execution plan?
