Re: ora2pg import

By default the Oracle schema is not exported into the PostgreSQL database
and all objects are created under the default Pgnamespace.

Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com

On Tue, Jan 29, 2019 at 10:40 PM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:

> Hello expert DBAs,
>
> would you please show me how to import scripts from Ora2pg into postgres
> db using each schema?
> From ora2pg, there's no export the whole database but one by one schema.
> Do I need to create each schema on postgres db and how do I run the export
> script per schema? If I import them by postgres all the tables, index,
> etc... will be under postgres user right?
>
> what I need to do for this import from sources of Oracle?
> thank you.
>
>
>
> *Bach-Nga*No one in this world is pure and perfect. If you avoid people
> for their mistakes you will be alone. So judge less, love and forgive more.
> To call him a dog hardly seems to do him justice though in as much as he
> had four legs, a tail, and barked, I admit he was, to all outward
> appearances. But to those who knew him well, he was a perfect gentleman
> (Hermione Gingold)
>
> **Live simply **Love generously **Care deeply **Speak kindly.
> *** Genuinely rich *** Faithful talent *** Sharing success
>