Hi, I know this will be a very simple one for you DBAs out there. we use Oracle 11g. I'm just trying to backup an existing table (SY811.F986101). I'm currenty connected via SQL Developer. I can do a select * from to pull all recordsfrom this table so I know I am connected to the DB and table successfully.
But when I try to execute the following command to create an exact copy of the table I get the attached syntax error. What am I missing??? Thanks.
SELECT * INTO SY811.F986101BKJ FROM SY811.F986101
So F986101BKJ is the backup table.