Re: I can attach in SQL Server, but can I in Oracle?

Daniel,

I have been to http://tahiti.oracle.com and am still at a loss about how to [Quoted] do the specific task.

As best I can determine from the responses to date for the Oracle installs, it appears that creating SQL scripts to create the tables and load the data is floating to the top of the list based on "ease of installation". I've tried to understand software like TOAD, SQLDump, etc. to make sure I can create the required scripts -- this may include manually modifying the scripts to reflect any syntactical differences between what Oracle requires and the generated script.

Have you any comments or recommendations on SQL script generators? I looked on every site I could find and it appears that these two might work (I know that SQLDump is primarily aimed at SQL Server, but it appears that it can generate a script for the INSERTs that can be modified.). I also found scripts that read through a table and generate INSERTs, but the testing I've done so far leads me to believe that either TOAD or SQLDump would be better.

I checked out the book you recommended and Tom has a new release of the book due out this month from Apress (August 13th). The previous version is no longer in print.

It's 1328 pages according to Apress ... looks like I'll have a lot to read. <G> I'll order it online today.

Many thanks for the recommendation.

Ron

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F3521D6.EB5BAB1A_at_exxesolutions.com...
> > > Daniel Morgan
> > > http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> > > damorgan_at_x.washington.edu
> > > (replace 'x' with a 'u' to reply)
> > >
> > >
>
> Good start ... but what you really need to do is go to
http://tahiti.oracle.com
> and look up the database architecture and concepts documents.
>
> The most critical part you must understand is the mutliversion concurrency
> model. If you don't you may be in for a rude surprise in the future. If
you can
> find, borrow, or beg a copy of Tom Kyte's "Expert one-on-one Oracle" do
so. The
> first three chapters are essential reading for what you are attempting.
>
> BTW: My comments to you are based on many years and many projects that
followed
> the pattern of SQL Server developers building something that appeared to
work
> ... right up until it didn't. My notes are cautionary ... not screams that
the
> sky is falling.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Sat Aug 09 2003 - 19:40:05 CEST