Nearly 7,000,000 Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!
If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!
Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.
Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.
- I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
- I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
- I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.
Go!
8,140 Comments
I’m not able to find this answer anywhere. In SQLcl there is a command called INFO (INFORMATION)
I’m trying this command on an object in a different schema which I have access to. But the info command tells med the object does not exist.
One would think the DDL command uses the same privileges as that command works fine on any object.
But INFO just gives be the error the object does not exist
DDL differentuser.tabobject OK
INFO differentuser.tabobject Doest not work.
The object is present in all_objects
Just can’t figure out why….
I’m guessing this is for a specific object, not for ‘all’ objects outside your schema.
In SQL Developer, run the command as a script, and observe the Log, Statements panel. You’ll see all the SQL we run, including that to resolve the object name.
Here’s the first thing we run –
begin
dbms_utility.name_resolve(
name => :name,
context => :ctx,
schema => :schema,
part1 => :part1,
part2 => :part2,
dblink => :dblink,
part1_type => :part1_type,
object_number => :num
);
end;