Home > Default > Question about CTAS in Enterprise Manager (definitely not urgent ;) )

Question about CTAS in Enterprise Manager (definitely not urgent ;) )

November 30Hits:0
Advertisement
Good afternoon,
I am following the OBE steps given in the link:
http://st-curriculum.oracle.com/obe/db/11g/r2/2day_dba/monitoring/monitoring.htm
On step *12.* the following instructions are given:
12.       
Enter employees1 in the Name field. Specify SYSTEM as the
schema and TBSALERT as the tablespace. Click on the Define Using
drop-down list and select SQL. The page is refreshed. Enter
select * from hr.employees in the CREATE TABLE AS field.
Click Options.In my installation of EM, the "Define Using" drop down list simply won't drop down and I am forced to define the fields individually instead of through a CTAS.
The question is: Are you able to choose "SQL" from the "Define Using" drop down list (which would indicate that I am doing something wrong) or do you experience the same problem I am ?
Thank you for your help,
John.

Answers

>
Not sure why my answer was "correct" ;)
>
well... it's correct because you tried it and you told me how it's working for you - that's all I needed :) Now I know that the problem is something wrong in my installation and not another "quirk" in EM.
>
None of the drop-down options look to be "special".
>
That's the only drop down that isn't working for me. All the drop downs in other pages work as expected. I thought it might be a bug in EM but, figured I'd ask this question to see if other people experience the same problem. Since the answer is "no"... then there is something wrong with my installation. Why only that drop down is affected is beyond me but, it is most likely an inadvertent mistake on my part.
Thanks,
John.

Read other 5 answers

Tags:

Related Articles

  • Question about CTAS in Enterprise Manager (definitely not urgent ;) )November 30

    Good afternoon, I am following the OBE steps given in the link: http://st-curriculum.oracle.com/obe/db/11g/r2/2day_dba/monitoring/monitoring.htm On step *12.* the following instructions are given: 12.        Enter employees1 in the Name field. Specif

  • How to configure Enterprise Manager in Active Data Guard?November 30

    Hi, I have installed oracle 11g r2 rac with asm in two nodes. OS is hp-Unix. I have installed oracle11g Active Data Guard using Single alone Database. Both RAc and Active Data Guard works fine. I have not configure Data Guard Broker. Question: How to

  • How to configure Enterprise Manager both node (2 node) RAC?November 30

    Hi, I have installed oracle 11g r2 rac with asm in two nodes. OS is hp-Unix. I have installed oracle11g Active Data Guard using Single alone Database. Both RAc and Active Data Guard works fine. I have not configure Data Guard Broker. I have configure

  • Newbie Oracle Enterprise Manager 11g feature availability questionOctober 11

    Newbie question here. I am new to Oracle 11g and new to this forum. I ran a search on this question and came up empty so hopefully there is a kind and knowlegable soul wo can help. I recall in earlier versions of Oracle Enterprise Manager for earlier

  • Enterprise Manager questionNovember 30

    Grid Infrastructure version: 11.2.0.3 RDBMS Version : 11.2.0.3 Platform : Oracle Linux 6.3 Before I start , I have to admit that I am not a OEM person . We are going to create 8 RAC DBs in 8 dedicated two-node Clusters . I want to configure Oracle En

  • Can not start Enterprise Manager web pageOctober 11

    I can not start Enterprise Manager web page. Here is my steps: 1. Start enterprise manager emctl start Waiting for EM to initialize ...Started 2. Check status: emctl status EMD is up and running : 200 OK 3. Start the web page http://myhost:1810/ 4. g

  • Error ORA-12560 prompts when trying to log in to the Enterprise ManagerOctober 11

    Hi all, I am a newbie to Oracle. Just installed the Oracle 9i Database Enterprise Edition (9.0.1) into Windows Server 2003 Standard Edition. Problem is encountered when trying to log in to the Enterprise Manager Standalone mode using either system/or

  • Installation problem with Enterprise Manager ConsoleOctober 11

    When i am installing 10G database installation was failed at configuring DBConsole. later from OUI(Oracle Universal Installer) i uninstalled Enterprise Manager Console. my Question was how to reinstall the Enterprise Manager Console alone? When i am

  • Enterprise Manager is taking to much time to open.October 11

    Hi ! there i am using oracle 10g for linux .I did some practice on backup and Recovery after that whenever i tried to open my Enterprise Manager it takes to much time to open.plz help me . thanksHans is right. " Use this forum to report broken links

  • Enterprise Manager is not able to connect to the database instance. The staOctober 11

    Enterprise Manager is not able to connect to the database instance. The state of the components are listed below. Listener is shown as unavailable. lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-NOV-2012 11:52:40 Copyright (c

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.619 s.