Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral


About burleson

  • Rank
    Advanced Member

Recent Profile Visitors

5,383 profile views
  1. burleson

    Complex query - help needed :)

    Hi Romntkac, I would consider using the “with” clause: http://www.dba-oracle.com/t_with_clause.htm Good luck!
  2. Hi again, To get an old plan, user the techniques above to get the plan, and then make a SQL profile for it. Then, swap the current plan with the older plan: http://www.dba-oracle.com/t_swapping_sql_profiles.htm You can also do this with Optimizer plan stability (stored outlines): http://www.remote-dba.net/t_op_sql_hinted_query.htm Have fun!
  3. Hi Pravin, and welcome to the forum! There are many ways to freeze SQL plans, read here: http://www.dba-oracle.com/oracle11g/oracle11g_sql_plan_management.htm And here: http://www.rampant-books.com/art_foot_plan_stability.htm And SQL profiles: http://www.dba-oracle.com/t_sql_profiles_replace_stored_outlines.htm Good luck!
  4. burleson

    Database connection only by a specific user

    Hi Hugo, A simple sution would be to revoke the “connec”, “resource”, and “create session” roles from all users except the one that you want to connect. Let us know if this works for you.
  5. Hi Rich, Thanks for the update! Yake care . . .
  6. You has complete directions! This forum is for answering questions! This is not a question, it is a request for free support services. For that, you need to do a service request on MOSC: http://support.oracle.com If you do not have not purchased Oracle support, you can call (800) 766-1884, give your credit card number for $1,000, and we will assign a consultant to help you. http://www.dba-oracle.com/consulting_prices.htm In the future, only post specific questions. Good luck! Good luck!
  7. burleson

    Kerberos authentication using AD

    Hi Amit, i don’t know why the OS should matter, but you can check on MOSC and know for sure: http://support.oracle.com Did you collect a trace file as the error message suggested?
  8. burleson

    Database link from Oracle to SQL Server

    Hi Vipon, and welcome to the forum! I have complete instructions here: http://www.dba-oracle.com/t_database_link_sql_server_oracle.htm Step-by-step instructions here: http://www.dba-oracle.com/t_heterogeneous_database_connections_sql_server.htm Good luck!
  9. burleson

    Export Issue

    Hi, I would start by using the full path when using the CREATE DIRECTORY statement: http://www.dba-oracle.com/t_oracle_create_directory.htm You also need to specify the dump_dir on the expdp invocation. See working example here: http://www.dba-oracle.com/t_rman_166_expdp_example.htm Good luck!
  10. burleson

    Kerberos authentication using AD

    Hi Amit, and welcome to the forum! First, try this change to SQLNET_AUTHENTICATION_SERVICES: http://www.dba-oracle.com/t_ora_12638_credential_retrieval_failed.htm Also, per the error, get a trace file. Good luck!
  11. Hi, and welcome to the forum! This is a good question, but I have never tried it. You should be able to build a simple test procedure of bested execute immediate calls and see if you get an error! You could create a dummy table and use the execute immediate to delete specific rows: http://www.dba-oracle.com/t_oracle_execute_immediate.htm Let us know the results of your test. I have also asked Bob Ganesan, a PL/SQL guru, to pop-in and advise you. Good luck!
  12. Hi Rich, Yes, ASM is part of the Oracle grid infrastructure: https://docs.oracle.com/cd/E11882_01/install.112/e47689/oraclerestart.htm#LADBI1212 Do you want to use ASM? I think that you can still create a vanilla database without using grid or ASM. But you are correct, in 12cR2 you must install the grid infrastructure: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-aix-12201-3677038.html Or this page: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Please let us know if this is the right download. Good luck!
  13. burleson

    18c user defined sharding

    Hi Kahloon, As I noted, I have not used sharding, so I cannot help much! I would post this question in the Oracle Support forum on MOSC. They have experts on call to assist you: http://support.oracle.com Please post the solution when you find it. Good Luck!
  14. Hi Bandi, You know, if you are running this in production, you may want to do a count(*), since you risk causing SQL execution plans from changing. To include non-partitioned tables, join into dba_tables, or better still, use the UNION operator. If you choose a join you may also need to qualify the join where partitioned=“NO’ . If you don’t want to write the query yourself, I may have this script in my script collection: http://www.rampant-books.com/download_adv_mon_tuning.htm Good luck!
  15. burleson

    18c user defined sharding

    Hi, and welcome to the forum! I have not used sharding, but let’s see what I can find. First, be careful on how you spell sharding: http://lmgtfy.com/?q=Sharting Anyway, as I understand user defined sharding, it is just a way to map tablespace stocks multiple servers. http://www.dba-oracle.com/t_sharding.htm ============================• 1 - Can I see your split command please? This doc may be helpful: https://docs.oracle.com/en/database/oracle/oracle-database/18/shard/sharding-methods.html#GUID-DA34E219-A601-40B3-A6E4-6545CA2EBB0B You may want to check MOSC on the recursive SQL erred, it It may be a bug: http://support.oracle.com ============================ 2 - bulk load Are you using oracleloader? I think that you can still run parallel SQL*Loader for bulk loads: http://www.dba-oracle.com/tips_sqlldr_loader.htm Would this work for you? ========================== 3 - offload data from sharded partition By offloading, you don’t mean Exadata cell offloading, right? And this is not using data pump expdp, right? Can you please explain how you define offloading? Please advise. , .