SQL Developer Import

All posts relating to Oracle database administration.

Moderator: Tim...

SQL Developer Import

Postby dnunknown » Fri Apr 26, 2013 5:48 pm

Hi Tim,

I have started an export of a DB via SQL Dev Version 3.0.04

At first this was a single file, but when the file got to a size that I could not burn to media to restarted it using the multiple files option

This export is of all objects and all rows for one schema including dependancies

My questions are;

- how to import the database schema using SQL Dev?
only see how to import data into an existing table, not an entire schema of new objects
- using multi file option it looks like it is creating a .sql file for each object, how does it know the order to import these objects again due to dependancies?

Unfort I am not able to connect directly to the server to run exp or expdp as I normally would so hitting a few snags w/ this tool. I can however if needed connect to the destination server to run imp or impdp

Thanks,
Steve
dnunknown
Advisor
 
Posts: 282
Joined: Wed Aug 01, 2007 5:35 pm
Location: Boulder, CO USA

Re: SQL Developer Import

Postby Tim... » Fri Apr 26, 2013 5:59 pm

Hi.

1) Check out the second picture down for the import of schema.

http://www.oracle-base.com/articles/mis ... orts_impdp

2) The order of events is fixed. Objects are created, data is imported and then constraints are created, so you won't try to create constraints before the tables are created etc. Just make sure Data Pump has access to all the files and it will do things is the correct order.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: SQL Developer Import

Postby dnunknown » Fri Apr 26, 2013 6:07 pm

Great - guess only concern now is the source data is an 11.2 DB the destination will be 10.2 DB will this be compatable?
dnunknown
Advisor
 
Posts: 282
Joined: Wed Aug 01, 2007 5:35 pm
Location: Boulder, CO USA

Re: SQL Developer Import

Postby Tim... » Fri Apr 26, 2013 10:06 pm

Hi.

It will work if you export using the VERSION parameter, set the the destination version.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: SQL Developer Import

Postby dnunknown » Sat Apr 27, 2013 12:14 am

Great - as always thanks Tim
dnunknown
Advisor
 
Posts: 282
Joined: Wed Aug 01, 2007 5:35 pm
Location: Boulder, CO USA

Re: SQL Developer Import

Postby Tim... » Sat Apr 27, 2013 6:46 am

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 8 guests