oracle - Pl-Sql User Connection -
i've been starting oracle on job. i've been using ms time. have problem on user-shema structure. tryed create table sql query, table had been created in somewhere else wanted. (i've created user named lpa) wrote query, , table in (generaldatabase) tablespaces->users->(here). want create table in lpa schema, under table folder. i've been searching could'nt it. need please. ps:i found need connect user, write query ts_lpa(thats tablespace). cant connect user lpa.(we can first problem) in oracle there no "dbo" or default schema, in case looking for. must specify target user account when connect (log in) database, , account used default schema of subsequent actions. (this similar home directory in linux, if log in williamr , create file, belong williamr , not generic default account.) in case suspect connecting sys or similar, in case table belongs sys (or whoever connected as). you'll need drop , try again. if don't want p...