>
> Hi ari
>
> I recently purchases your oracle8 - How To book with is very good. I have all
> read your technical reponses which I found quite useful
>
> I was hoping you could help me witha small problem
>
> I have got two instances on one machine a production and a development
> instance.
>
> There have been time when I needed to copy a table from the development to
> the production instance, but when I do that it does not seem to recreate all
> the triggers, constraints, indexes etc
>
> Is there an easy way to copy a table with all its indexes , constraints etc
>
> regards
>
> michael Dsouza
>
>
>
Glad you like the book.
To copy a table with all indexes, constraints, triggers, grants, etc.
you need to EXPORT the table from one instance and
IMPORT it into the other.
To get all of the commands, you can type
IMP SHOW=Y to see all of the CREATE commands.
Best of luck,
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page