This content has been marked as final. Show 6 replies
I have to create some scripts to create a new and empty DB ready for a new install of our apps on a new server.
I am easily getting the tables, views etc info from SQL Developers Export facility (without the data of course), but I have a problem where I need to define the userid and the TableSpace.
I realise these are quite straight forward, but what I would like to know is how the original ones are defined on our current DB, as the original scripts (and info) are no longer available, and I need to make sure I create them correctly with the new scripts.
So how do I display all the required info for a userid and for a TableSpace so that I can use this info in the create commands in the scripts ?
It may be helpful for you to know this is my first attempt at scripting and only my 2nd attempt at and interfacing with Oracle, so I have limited knowledge in this field, hence the simple request. :)
Any help or advice would be most appreciated.
or just export (expdp) & import (impdp)
Read The Fine Manuals found at http://docs.oracle.com