This content has been marked as final. Show 16 replies
Which GUI are you using? Try with XMING am sure it will take just 15 to 20 minutes max time to complete.
Check below url for more info.
Mark as correct if it is helpful..
Whathas to do XMING server. Its not time the concern, but avoiding clicking the choices on the GUI every time.
I found also such resources, beifre that what is most important,
if you know on how many steps (scripts+distinct required commands) its possible.
Can all commands - to achieve those configurations needed - be put into a MEGA SCRIPT so to execute just that and end of the story.
Or which are the minimum steps possible at least? (approximately)
Always the identical configurations areneeded for every DB I have to create.
You have 2 options if you DON'T want to go through the GUI:
1. Create database manually through CREATE DATABASE command, and scripts.
2. Create a database through DBCA in Silent MODE (non - interactive)
So way 2 with Silent Mode is it possible in one step as it seenms ?!
You can exaclty put ALL your personal parameters from a file, and end of the story ?!
But way 1 with CREATE DATABASE is it the same fast in one step - if you manage to create te complex statement ?
or executions of other commands is required afterwards make it more time consuming?
TARGET IS the most automated process possible for creating the database, with the fewer steps-user intervent
! WOW can it be so simple ?!
Thank you very much !
For way 1 through CREATE DATABASE can it be the same simple and in 1 step,
so if you manage to create all the commands pack them in a mega- script also?
Or other eg console commands may be required and its not possible ?
Oh and don't forget, if possible I would like to pack also nts + tablespace creation.
Probably it can't be done from this script so
1. Can I execute the DBCA script from another script so to execute a nts confinguration script + the Tablespace script afterwards ?
Maybe this needs a different thread, deverges from tite a bit
Edited by: Goodfire on 17-May-2013 00:26
Edited by: Goodfire on 17-May-2013 00:31
Oh so in that same script I can afterwards setup the nts and the create tablespace wright
Problem : I selected only create scipts and press finalize but no script appears at selected directory lol, is it logical?
Do I have to select also create database and templates maybe?
Edited by: Goodfire on 17-May-2013 00:43
Edited by: Goodfire on 17-May-2013 00:47
Left the standard datapath and it worked lol. Still my path was on the same Disk. So funny problem
*2nd Part Question :* It has created many scripts. Which script is the last executed so I can put commands for NTS and CREATE TABLESPACE afterwards?
You sed it can be done in the script
Edited by: Goodfire on 17-May-2013 01:05
Edited by: Goodfire on 17-May-2013 01:07
Edited by: Goodfire on 17-May-2013 01:14