cLive ;-) has asked for the wisdom of the Perl Monks concerning the following question:
I've tried to create a DBIx Schema for an Oracle DB, but all I'm getting is the basic schema class. It's been a while since I've touched Oracle (and DBIx::Class from first principles), so I'm wondering if I'm missing something obvious.
perl -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:./lib -e 'make_schema_at("My::Schema", { debug => 1 }, [ ... credentials ... ]On running, I just get the one module:
./lib/My/Schema.pm
I was under the impression that I would get a full schema dump of all the tables in the DB.
Using the same credentials, I can get a $dbh and run the query
SELECT table_name FROM all_tables ORDER BY table_name
to get a list of all the tables, so why can't I get the Schema definitions for them? Would it be a user permission? If so, how would I check what perms my user has? At the moment, I'm going in blind and not sure what questions I need to be asking, so any insights appreciated. If I need to get a different user for this I guess I'll put in the request, but I was hoping to be able to work it out with what I have.
Running SELECT * FROM USER_TAB_PRIVS I see a bunch of select/update/execute perms.
Running SELECT * FROM USER_SYS_PRIVS gives me nothing.
Running SELECT * FROM USER_ROLE_PRIVS gives me a bunch of perms (not sure what they all are just yet, only that they exist).