perlquestion
cLive ;-)
<p>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.</p>
<code>perl -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:./lib -e 'make_schema_at("My::Schema", { debug => 1 }, [ ... credentials ... ]</code>
<p>On running, I just get the one module:</p>
<pre>./lib/My/Schema.pm</pre>
<p>I was under the impression that I would get a full schema dump of all the tables in the DB.</p>
<p>Using the same credentials, I can get a $dbh and run the query</p>
<pre>SELECT table_name FROM all_tables ORDER BY table_name</pre>
<p>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.</p>
<p>Running <b>SELECT * FROM USER_TAB_PRIVS</b> I see a bunch of select/update/execute perms.</p>
<p>Running <b>SELECT * FROM USER_SYS_PRIVS</b> gives me nothing.</p>
<p>Running <b>SELECT * FROM USER_ROLE_PRIVS</b> gives me a bunch of perms (not sure what they all are just yet, only that they exist).</p>