 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Topic starter
In oracle sql:
Create table area1.customer (columns etc...) tablespace area2
Is this statement valid? If so what is area1 specifying? is it a user? or a schema?
Been a while since I had anything to do with oracle.
Ta
Posted : 05/09/2017 2:35 pm
It's the schema
Posted : 05/09/2017 2:39 pm
Topic starter
So
area1 is the schema.
area2 is the tablespace.
Ta
Posted : 05/09/2017 2:48 pm
Yes
Posted : 05/09/2017 2:57 pm
Sorry for the abrupt answers, I can't think of anything further that would be useful to add 🙂
Posted : 05/09/2017 2:59 pm
Schema / User, tomata / tomato?
Posted : 05/09/2017 3:10 pm
Topic starter
No worries - thanks Rubber.
Just trying to work out if Area1/Area2 is a typo. It's probably not a type - but whoever named the Schema and Tablespaces on this system should be shot.
Posted : 05/09/2017 3:21 pm