Conf. Change Required at Client side When DB migrated
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Conf. Change Required at Client side When DB migrated

  1. #1
    Join Date
    Apr 2003
    Posts
    353

    Conf. Change Required at Client side When DB migrated

    We changed our database from 8i to 9i.

    when we traced the client sql's it is adding a
    double quotes with all columns, in the Current sql.

    example

    select emp."emp_name", emp."sal" from emp;

    But when the same application when we run from 8i
    the sql at the backend is

    select emp.emp_name,emp.sal from emp;

    Is there any performance issues? Is there any client side configurtion
    change required to change the above..?

    Thanks

  2. #2
    Join Date
    Jul 2002
    Posts
    335
    No there are no issues with this. If you extract ddl using OEM, OEM will put these quotes all over the place.

    They don't do any harm. be wary when creating tables, adding columns though, you can, via the use of quotes, make table names and column names case sensitive (or even blank!).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width