Exporting Remote Oracle Database when host and port address are provided

To export a remote oracle DB we can use an alias from tnsnames.ora, or provide a connection string in a similar format :

exp user/password@host:port/service_name

Note that this requires the service name of the database, which might not be the same as the SID. We can get the services by running lsnrctl services on the remote server or by querying the v$parameter view , or by asking the DBA for the remote server.

The connection options are the same as for any other tool, so if we can connect to the remote database using SQL*Plus then we can use the same connect string for exp.

If you’re using @database to connect to a local instance then that is probably already defined in your tnsnames.ora, and you could add entries for the remote database there too.

Also, if you’re not still on an old version (pre-10g), you should use datapump (expdp) rather than the old exp tool.

The ThemeShaper WordPress Theme Tutorial: 2nd Edition



Many of you have written or commented to tell us how much you liked Ian Stewart’s original tutorial, “How To Create a WordPress Theme: The Ultimate WordPress Theme Tutorial”. You’ll be happy to learn that that we’ve created a second edition of the tutorial! Just like last time, you can expect one new lesson each day. What’s changed in the second edition? Keep reading to find out!

What’s new in the Second Edition:

  • Updated code samples that draw from the Underscores (_s) starter theme.February 2012 marked the release of the Underscores (_s) starter theme, and since then, it has gathered plenty of momentum. The code samples and file structure for the theme we’re going to create in this tutorial will draw from _s as a source of modern code that reflects current best practices.
  • New Lessons.Developing Your Theme Sense is worth reading if you’re…

View original post 729 more words