Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re: Using DBIx::Class::Schema::Loader with Oracle

by silent11 (Vicar)
on Jun 15, 2022 at 04:39 UTC ( #11144755=note: print w/replies, xml ) Need Help??

in reply to Using DBIx::Class::Schema::Loader with Oracle

I'm not going to be much help, but I recall being in a similar situation 10+ years ago IIRC. I found a binary in either the DBIC or Oracle path that either started or ended with table that gave me a nice print out of all the tables. I was able to eventually get DBIC::Schema::Loader to dump everything and I got everything. Every little tiny object the database had, however it took forever to generate, and it generated waaaaay more schema than I wanted, I'm talking every user/schema I had read access to, every table, view, sequence, object, etc, etc, etc.. I think I ended up specifically targeting the a) schema and b) table(s) I was interested in.

update: have you tried passing dump_directory?

make_schema_at('Company::Project', { debug => 1, dump_directory => './lib'}, [credentials...] );

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11144755]
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (4)
As of 2023-12-10 06:40 GMT
Find Nodes?
    Voting Booth?
    What's your preferred 'use VERSION' for new CPAN modules in 2023?

    Results (38 votes). Check out past polls.