Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-00923: FROM keyword not found where expected

JhilApr 5 2021

Dear Experts,

May I know why I am getting an error of below SQL
SQL> select 'select DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','''||USERNAME||''') from dual; 'from dba_users where username like 'SMS%';
select 'select DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','''||USERNAME||''') from dual; 'from dba_users where username like 'SMS%'
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected

Thanks
This post has been answered by BEDE on Apr 5 2021
Jump to Answer

Comments

BluShadow

*** Moved to VirtualBox for better question alignment as "Documentation" is not the correct space to ask such a question - let me know if there's a more suitable Virtual product space and I can move it again if needed.

37660ed0-2283-43d5-9d12-8f57a6f3c35b

Can someone please answer above query? Thanks.

Nik

Hi.

Read this:

http://www.oracle.com/technetwork/server-storage/solaris11/documentation/solaris-11-3-faqs-2489291.pdf

Some parts from this Doc.

Q: Can I install Oracle Solaris 11 into a virtual environment?

A: Yes. Oracle Solaris 11 is a supported guest operating system on Oracle VM Server for SPARC, Oracle VM Server for x86, and Oracle VM VirtualBox. Oracle Solaris 11 is known to work on a number of other third-party virtualization offerings from vendors including VMware, Microsoft, and Red Hat.

So Solaris 11 work on VmWare platform, but not supported.

Regards,

Nik.

ErikB

Yes, it is supported.

For step by step directions on how to install look here; Installing Solaris x86 11.2 from an ISO in Virtualbox – Part 1 - Tales from the Datacenter

Erik

Wesley D-Oracle

Solaris 11 can run in VMware; however, only the x86_64 variant - as VMware does not have the ability to emulate SPARC architecture.

I suggest looking at VMware Sites for further information and support with installing Solaris 11 x86_64 as a guest virtual machine on VMware.

1 - 5

Post Details

Added on Apr 5 2021
2 comments
108 views
1 mention