no sir i just want to see what's the error at the second line which i posted in previous posts... After i am typing the whole scripts in the method its giving the error in the line 2.. I want you to look at that

as soon as i am typing the first line i.e. create database demo and the i am typing the next line as {datafile '/home/oracle/app/oracle/oradata/test/system.dbf' size 300m;} I am not giving any space after that first line... The procedure i posted is document of step by step procedure.. I am not giving any gap between any lines... I typed the whole procedure in the editor and after executing all the steps in SQL its giving the error in the first line.. After that when I am getting errror while typing in the editor I tried typing in the SQL, soon after typing the second line {datafile '/home/oracle/app/oracle/oradata/test/system.dbf' size 300m;} the error is

[create database test*ERROR at line 1:ORA-30045: No undo tablespace name specified ].. Please tell the step by step procedure to rectify the error.... Please remember i am not at all using any spaces...

The first thing I would do it put your command into a script and run that rather than typing. it's much more efficient. You can run a script in sqlplus using:

SQL> @/path/to/script.sql

Where "/path/to" is the real path substituted and script.sql is the name of your script.

The second thing I would do is generate the create database scripts using the DBCA, then compare your script to the generated script. That should give you an idea of where your script is wrong.

As I've said before, it is many years since Oracle recommended manually building databases rather than using the DBCA to generate them. You should probably ask your lecturer why he/she is asking you to do something that is not considered good practice.

Also, please stop putting "Please tell the step by step procedure to rectify the error". It's a sure fire way to piss anyone off on a forum. When people are helping you for free you can't demand any level of service. The manuals are available for free ans provide step by step instructions. If that is what you want I suggest you read them.

Ok I am extremely sorry Sir.. I didn't have any intensions to demand you..I was just requesting you for that. I dont know about that. Infact you are the person helped me a lott and I am very thankful to you for that..