Home » RDBMS Server » Server Administration » What happens when a table is created??
What happens when a table is created?? [message #59635] Wed, 10 December 2003 18:27 Go to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
Hi All,
What happens in Oracle when a create table command is issued successfully??
What I know that first it is parsed in library cache, then the structures are written in Data dictionary. But I was expected some other relevant answer. Can anyone suggest the relevant answer....

TIA,
Sachin

Report message to a moderator

Re: What happens when a table is created?? [message #59636 is a reply to message #59635] Wed, 10 December 2003 19:52 Go to previous messageGo to next message
L
Messages: 2
Registered: January 2003
Junior Member
The Alert log file is updated with the DDL command??

Report message to a moderator

Re: What happens when a table is created?? [message #59638 is a reply to message #59635] Wed, 10 December 2003 22:12 Go to previous messageGo to next message
Sukunda Dongol
Messages: 1
Registered: December 2003
Location: Kathmandu
Junior Member
Hello,
I have installed windows 2000 and i also have installed developer 6i after that i installed oracle 9i there was not any error message shown in the installaing period after installaing oracle at last period i got error message That is " ORA-1503 CREATE CONTROLED FILE FAILED " what is that problem ???

Report message to a moderator

Re: What happens when a table is created?? [message #59640 is a reply to message #59636] Thu, 11 December 2003 03:49 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Nope,not for this one.

Report message to a moderator

Re: What happens when a table is created?? [message #59641 is a reply to message #59638] Thu, 11 December 2003 03:52 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Maybe the controlfile you are about to create already exists or you dont have permissions etc..Also see the accompanying errors.

BTW,Post new questions separately..

-Thiru

Report message to a moderator

Re: What happens when a table is created?? [message #59649 is a reply to message #59635] Thu, 11 December 2003 05:48 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Right, Parsing in Library cache(includes data dictionary lookups), data dictionary updates( obj$,tab$,col$,seg$ etc ), the actual allocation of extents and blocks in the datafiles,writing of the redo information into online redolog files via log buffer cache ...

-Thiru

Report message to a moderator

Previous Topic: windows error
Next Topic: Cleanup Performance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:17:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.